DB
FunctionsType Conversion

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.

coalesce(…) → Dynamic

Kind · scalar

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.

Part of the Type Conversion family.

castas

Casts each input value to a target type provided by argument. Supported targets include text/string, int, float, bool, bytes, time, timestamp, uuid/timeuuid, varint, tinyint, and counter.

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