FunctionsType Conversion

is_null

Returns true if the input value is NULL, otherwise returns false. This is a functional form of the IS NULL predicate for use in expressions and higher-order functions.

is_null(…) → Bool

Kind · scalar

Returns true if the input value is NULL, otherwise returns false. This is a functional form of the IS NULL predicate for use in expressions and higher-order functions.

Part of the Type Conversion family.

is_not_null

Returns true if the input value is not NULL, otherwise returns false. This is a functional form of the IS NOT NULL predicate for use in expressions and higher-order functions.

multi_if

Evaluates condition/value pairs left to right and returns the value corresponding to the first condition that is true. If no condition is true, returns the final default argument. Useful as a compa…