Module expr_fn

Available on crate feature core_expressions only.

Functions§

arrow_cast: Returns value2 if value1 is NULL; otherwise it returns value1
arrow_typeof: Returns the Arrow type of the input expression.
coalesce: Returns coalesce(args...), which evaluates to the value of the first expr which is not NULL
get_field: Returns the value of the field with the given name from the struct
greatest: Returns greatest(args...), which evaluates to the greatest value in the list of expressions or NULL if all the expressions are NULL
least: Returns least(args...), which evaluates to the smallest value in the list of expressions or NULL if all the expressions are NULL
named_struct: Returns a struct with the given names and arguments pairs
nullif: Returns NULL if value1 equals value2; otherwise it returns value1. This can be used to perform the inverse operation of the COALESCE expression
nvl: Returns value2 if value1 is NULL; otherwise it returns value1
nvl2: Returns value2 if value1 is not NULL; otherwise, it returns value3.
struct: Returns a struct with the given arguments
union_extract: Returns the value of the field with the given name from the union when it’s selected, or NULL otherwise