NULL()

All functions > CORE > NULL()

Returns a NULL value of the given type.

Signatures

Returns: A NULL value of the specified type

NULL([type: DataTypeEnum.TYPE]) → T

Notes

• Creates a typed NULL value
• If no type specified, defaults to VARCHAR
• Useful for providing explicit NULL values in expressions
• Type parameter ensures proper type inference in complex queries
• NULL values propagate through most operations
• Can be used to initialize optional fields or provide default values

See also

• Core functions

Examples

Typed NULL

SELECT
    f1 := COALESCE(NULL(BIGINT), 7), -- NULL(BIGINT) carries BIGINT so COALESCE can fill in a default
    f2 := (NULL(BIGINT) IS NULL::BIGINT) = TRUE -- Explicit typed NULL compares with IS NULL
;

Default type when omitted

SELECT
    f1 := TYPEOF(NULL()) -- NULL() without a type is an unspecified NULL in FeatureQL typing
;