General Function Reference

!=

Check if two values are not equal. Returns NULL if either argument is NULL.

<

Check if the left value is less than the right. Returns NULL if either argument is NULL.

<=

Check if the left value is less than or equal to the right. Returns NULL if either argument is NULL.

<>

Check if two values are not equal. Returns NULL if either argument is NULL.

=

Check if two values are equal. Returns NULL if either argument is NULL.

>

Check if the left value is greater than the right. Returns NULL if either argument is NULL.

>=

Check if the left value is greater than or equal to the right. Returns NULL if either argument is NULL.

and

Boolean and all inputs.

is_distinct_from

Check if two values are not equal, treating NULLs as normal data values.

is_false

Check if a value is false.

is_not_distinct_from

Check if two values are equal, treating NULLs as normal data values.

is_not_false

Check if a value is not false.

is_not_null

Check if a value is not NULL.

is_not_true

Check if a value is not true.

is_null

Check if a value is NULL.

is_true

Check if a value is true.

not

Returns TRUE if the input is FALSE, and FALSE if the input is TRUE.

or

Boolean or all inputs.

struct_extract

Extracts a value from a struct.