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.

Syntax

IS_SCALAR(super_expression)

Arguments

super_expression

A SUPER expression or column.

Return type

BOOLEAN

Examples

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(s.name) FROM t; +----------------+-----------+ | s | is_scalar | +----------------+-----------+ | {"name":"Joe"} | true | +----------------+-----------+