1.1

Numeric expressions
Numeric expressions are expressions that result in numeric values. Most of the general expressions can result
in numeric values. Numeric values have one of the following types:
• BIGINT
• DECIMAL
• DOUBLE PRECISION
• INTEGER
• REAL
• SMALLINT
ExplanationExpression type
Evaluate the expected math operation on the operands. If both
operands are the same type, the result type is not promoted, so the
+, -, *, /, unary + and - expressions
division operator on integers results in an integer that is the truncation
of the actual numeric result. When types are mixed, they are promoted
as described in Data types.
Unary + is a noop (i.e., +4 is the same as 4).
Unary - is the same as multiplying the value by -1, effectively
changing its sign.
Returns the average of a set of numeric values.
AVG
AVG function
Returns the sum of a set of numeric values. SUM function
SUM
Returns the number of characters in a character or bit string. See
LENGTH function.
LENGTH
See LCASE or LOWER function.LOWER
Returns the count of a set of values. See COUNT function,
COUNT(*) function.
COUNT
Character expressions
Character expressions are expressions that result in a CHAR or VARCHAR value. Most general expressions
can result in a CHAR or VARCHAR value.
ExplanationExpression type
The wildcards % and _ make a character string a pattern against
which the LIKE operator can look for a match.
A CHAR or VARCHAR value that uses wildcards.
In a concatenation expression, the concatenation operator, "||",
concatenates its right operand to the end of its left operand. Operates
on character and bit strings. See Concatenation operator.
Concatenation expression
525
SQL Language Reference