IS_SCALAR function - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

IS_SCALAR function

Checks whether a variable is a scalar. The IS_SCALAR function returns true for any value that is not an array or an object. The function returns false for any other values, including null.

The set of IS_ARRAY, IS_OBJECT, and IS_SCALAR cover all values except nulls.





A SUPER expression or column.

Return type



To check if {"name": "Joe"} is a scalar using the IS_SCALAR function, use the following example.

CREATE TABLE t(s SUPER); INSERT INTO t VALUES (JSON_PARSE('{"name": "Joe"}')); SELECT s, IS_SCALAR( FROM t; +----------------+-----------+ | s | is_scalar | +----------------+-----------+ | {"name":"Joe"} | true | +----------------+-----------+