Skip to content

Other

General functions

Name Parameters Return Description
ISNULL ANY Boolean Return TRUE if the argument type is null.
ISNUMERIC ANY Boolean Return TRUE if the argument type is number.
TYPEOF ANY Text Return the argument type name.
GREATEST ANY, Any, ...Any Any Return the greatest value from list of values
LEAST ANY, Any, ...Any Any Return the smallest value from list of values
UUID Text Return a Universal Unique Identifier
IF Boolean, T, T T Return second argument if the condition is TRUE otherwise return last argument
IFNULL T, T T Return second argument if first one is null, otherwise return first one
BENCHMARK Integer, Expression Int(0) Execute the expression n times and return 0