| Module | Sequel::SQL::NumericMethods |
| In: |
lib/sequel/sql.rb
|
This module includes the standard mathematical methods (+, -, *, and /) that are defined on objects that can be used in a numeric context in SQL (Symbol, LiteralString, and +SQL::GenericExpression+).
:a + :b # "a" + "b" :a - :b # "a" - "b" :a * :b # "a" * "b" :a / :b # "a" / "b"
One exception to this is if + is called with a String or StringExpression, in which case the || operator is used instead of the + operator:
:a + 'b' # "a" || 'b'
Use || as the operator when called with StringExpression and String instances, and the + operator for LiteralStrings and all other types.
# File lib/sequel/sql.rb, line 416
416: def +(ce)
417: case ce
418: when LiteralString
419: NumericExpression.new(:+, self, ce)
420: when StringExpression, String
421: StringExpression.new('||''||', self, ce)
422: else
423: NumericExpression.new(:+, self, ce)
424: end
425: end