documentationvariant_null¶
Description¶
Returns a null value of type variant.
This is important because some functions, like case(), return more convenient outputs if all their arguments are of the same type.
Return type¶
variant
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
variant_null()
Examples¶
make_col positive_or_null:case(x > 0, x, true, variant_null())
Create a column ‘positive_or_null’ which is either a positive number or null with type variant.
Aliases¶
any_null (deprecated)