Special functions

Reference documentation for Expressif functions in the special scope.

Name	Overview
any-to-any	Returns any.
coalesce	Returns the first non-null result from two or more expressions evaluated from left to right against the same input. Returns null when every expression evaluates to null.
coerce	Coerces a scalar value or selected tuple and record values to requested Expressif types.
coerce-boolean	Attempts to convert the input to a boolean value. Returns null when the input cannot be converted.
coerce-date	Attempts to convert the input to a date value. Returns null when the input cannot be converted.
coerce-datetime	Attempts to convert the input to a date-time value. Returns null when the input cannot be converted.
coerce-int	Attempts to convert the input to an integer value. Returns null when the input cannot be converted without loss.
coerce-numeric	Attempts to convert the input to a numeric value. Returns null when the input cannot be converted.
coerce-text	Attempts to convert the input to a text value. Returns null when the input cannot be converted.
coerce-time	Attempts to convert the input to a time value. Returns null when the input cannot be converted.
neutral	Returns the argument value.
null-to-value	Returns the value passed as argument, except if the value is null then it returns value.
recode	Returns the dictionary value associated with the input key, or preserves the input when no key matches.
value-to-value	Returns value except if the argument value is null then it returns null.