Operators
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 |