DB
FunctionsType Conversion

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.

if_null(…) → Dynamic

Kind · scalar

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

Part of the Type Conversion family.

if

Evaluates a boolean condition and returns the 'then' value when the condition is true; otherwise returns the 'else' value. A NULL condition is treated as not true (so the else branch is returned).

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.