This table shows the operators associativity, starting from highest to lowest:
| Operator | Associativity | Comments |
|---|---|---|
. |
left | Field access |
:: |
left | Infix cast |
[ index ] |
left | Collection element |
+, - |
right | Unary plus, minus |
*, /, %, || |
left | arithmetic |
+, - |
left | arithmetic |
BETWEEN, IN, LIKE, SIMILAR, OVERLAPS, CONTAINS |
N/A | |
<, >, =, <=, >=, <>, !=, <=> |
left | comparisons |
IS NULL, IS FALSE, IS NOT TRUE |
unary | |
NOT |
right | Boolean |
AND |
left | Boolean |
OR |
left | Boolean |