FunctionsType Conversion

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).

if(…) → Dynamic

Kind · scalar

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).

Part of the Type Conversion family.

coalesce

Returns the first argument that is not NULL, scanning left to right. If all arguments are NULL, returns NULL. Commonly used to provide defaults or to normalize NULLs across multiple sources.

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.