Operators

.

Table/column name separator

CAST

Type cast

-

Unary minus

* /

Multiplication, division

+ -

Addition, subtraction

IS

IS [NOT] TRUE, IS [NOT] FALSE, IS [NOT] NULL, IS [NOT] DISTINCT FROM

||

Concat

IN BETWEEN LIKE

Set membership, range containment, string pattern matching

< > =

Less than, greater than, equality / assignment

NOT

Logical negation

AND

Logical conjunction

OR

Logical disjunction

EXCEPT

Returns rows except subset