Operators

Operator Precedence

CeloSQL supports the following operators in decreasing precedence:

Operator	Description
.	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