[] (array_construct)

Returns an array constructed from zero, one, or more inputs.

Syntax

[ [ <expr1> ] [ , <expr2> [ , ... ] ] ]

Arguments

The arguments are values (or expressions that evaluate to values). The argument values can be different data types.

Returns

The data type of the returned value is ARRAY.

Examples

Construct a basic array consisting of numeric data types:

SELECT [10, 20, 30];

+--------------+
| [10, 20, 30] |
+--------------+
| [10,20,30]   |
+--------------+

Construct a basic array consisting of different data types:

SELECT [NULL, 'hello', 3::float, 4, 5];

+---------------------------------+
| [NULL, 'hello', 3::float, 4, 5] |
+---------------------------------+
| [NULL,"hello",3.0,4,5]          |
+---------------------------------+

Construct an empty array:

SELECT [];

+----+
| [] |
+----+
| [] |
+----+