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 TRUE, IS UNKNOWN, IS NOT NULL, IS NOT TRUE, IS NOT FALSE, IS NOT UNKNOWN |
unary |
|
NOT |
right |
Boolean |
AND |
left |
Boolean |
OR |
left |
Boolean |