object_null

Description

Returns a null value of type object.

This is important because some functions, like case(), return more convenient outputs if all their arguments are of the same type.

Return type

object

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

• Semistructured

Usage

object_null()

Examples

make_col positive_or_null:case(x > 0, x, true, object_null())

Create a column ‘positive_or_null’ which is either a positive object, or the null object.