DB
FunctionsType Conversion

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…

multi_if(…) → Dynamic

Kind · scalar

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 compact alternative to nested if() or CASE.

Part of the Type Conversion family.

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.

null_if

Returns NULL if the two arguments are equal; otherwise returns the first argument. If the equality test is unknown due to NULLs, the first argument is returned (standard NULLIF behavior).