Skip to content

operators.md

Latest commit

 

History

History
75 lines (72 loc) · 1.67 KB

operators.md

File metadata and controls

75 lines (72 loc) · 1.67 KB

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, 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;