|
Expression precedence
Precedence of operations from highest to lowest is:
- (), ?, Constant (including sign), NULL, ColumnReference, ScalarSubquery,
CAST
- LENGTH, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, and other built-ins
- unary + and -
- *, /, || (concatenation)
- binary + and -
- comparisons, quantified comparisons, EXISTS, IN, IS NULL, LIKE, BETWEEN,
IS
- NOT
- AND
- OR
You can explicitly specify precedence by placing expressions within
parentheses. An expression within parentheses is evaluated before any operations
outside the parentheses are applied to it.
Example
(3+4)*9
(age < 16 OR age > 65) AND employed = TRUE
|
