FunctionsType Conversion

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.

is_not_null(…) → Bool

Kind · scalar

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.

Part of the Type Conversion family.

if_null

Returns the first argument if it is not NULL; otherwise returns the second argument. This is a two-argument convenience form of coalesce.

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.