ARRAY
更新时间：2025-10-17
描述
根据参数构造并返回 array, 参数可以是多列或者常量
语法
SQL
1ARRAY([ <element> [, ...] ])参数
| 参数 | 说明 |
|---|---|
<element> |
参数可以是多列或者常量 |
返回值
返回一个数组
举例
SQL
1select array("1", 2, 1.1);
Text
1+------------------------------------------------+
2| array('1', cast(2 as TEXT), cast(1.1 as TEXT)) |
3+------------------------------------------------+
4| ["1", "2", "1.1"] |
5+------------------------------------------------+
SQL
1select array(null, 1);
Text
1+----------------+
2| array(NULL, 1) |
3+----------------+
4| [NULL, 1] |
5+----------------+
SQL
1select array(1, 2, 3);
Text
1+----------------+
2| array(1, 2, 3) |
3+----------------+
4| [1, 2, 3] |
5+----------------+
SQL
1select array(qid, creationDate, null) from nested limit 4;
Text
1+-------------------------------------------------------+
2| array(cast(qid as DATETIMEV2(0)), creationDate, NULL) |
3+-------------------------------------------------------+
4| [null, "2009-06-16 07:40:56", null] |
5| [null, "2009-06-16 07:50:05", null] |
6| [null, "2009-06-16 08:09:18", null] |
7| [null, "2009-06-16 08:15:45", null] |
8+-------------------------------------------------------+