StreamSQL Type Check Functions

Type check functions are used for checking data types.

IS_NULL - Null Check Function

Syntax: is_null(value)
Description: Checks if a value is NULL.

IS_NOT_NULL - Not Null Check Function

Syntax: is_not_null(value)
Description: Checks if a value is not NULL.

IS_NUMERIC - Numeric Check Function

Syntax: is_numeric(value)
Description: Checks if a value is of numeric type.

IS_STRING - String Check Function

Syntax: is_string(value)
Description: Checks if a value is of string type.

IS_BOOL - Boolean Check Function

Syntax: is_bool(value)
Description: Checks if a value is of boolean type.

IS_ARRAY - Array Check Function

Syntax: is_array(value)
Description: Checks if a value is of array type.

IS_OBJECT - Object Check Function

Syntax: is_object(value)
Description: Checks if a value is of object type.

📚 Related Documentation

• Array Functions - Learn detailed usage of array functions
• Conditional Functions - Learn detailed usage of conditional functions
• SQL Reference - View complete SQL syntax reference