Logical and Comparsion ops

logical operators

support logical operators(and, or, not)

comparsion operators

support basic comparsion operators(<,>, <=, >=, =, <>, !=)

between (x) and (y)

The between operator tests if a value is within a specified range.

is null / is not null

is null and is not null operators test whether a value is null. Both operators work for all data types.

is distinct from / is not ditinct from

a null value is not considered distinct from NULL. When you are comparing values which may include NULL use these operators to guarantee either a TRUE or FALSE result.

SELECT NULL IS DISTINCT FROM NULL; -- false

SELECT NULL IS NOT DISTINCT FROM NULL; -- true

like

The like operator is used to match a specified character pattern in a string.