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

Arithmetic operations combining signed and unsigned values will produce a result with the wider type; if both types have the same width, the result is unsigned;