Expressions and Operators

Basic operators

Mathematical operators

OPERATOR	DESCRIPTION	EXAMPLE
+	Addition	1 + 2 results in 3
-	Subtraction	1 - 2 results in -1
*	Multiplication	2 * 2 results in 4
/	Division	6 / 2 results in 3
%	Remainder	5 % 4 results in 1
^	Exponent (association of left to right)	2.0 ^ 3.0 results in 8

Comparison operators

OPERATOR	DESCRIPTION	EXAMPLE
<	Less than	a < 5
>	Greater than	a > 5
<=	Less than or equal to	a <= 5
>=	Greater than or equal to	a >= 5
=	Equal	a = 5
<>	Not equal	a <> 5
!=	Not equal	a != 5

Logical operators

OPERATOR	DESCRIPTION
AND	Allows the existence of multiple conditions in a WHERE clause.
NOT	Negates the meaning of another operator. For example, NOT IN, NOT BETWEEN.
OR	Combines multiple conditions in a WHERE clause.

Conditional expressions and operators

Expression	Description
CASE	A conditional statement that allows you to perform conditional logic in queries, returning different values based on specific conditions being met.
CAST	Convert a value of one data type to another.

String operators

OPERATOR	DESCRIPTION	EXAMPLE
||	Concatenation	'a'
LIKE	Case-insensitive pattern matching	'a' LIKE 'A' results in true
ILIKE	Case-insensitive pattern matching	'a' ILIKE 'A' results in true