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