Expression Precedence

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.

The 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

Example

(3+4)*9 
(age < 16 OR age > 65) AND employed = TRUE