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 NOT TRUE	unary
NOT	right	Boolean
AND	left	Boolean
OR	left	Boolean