Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/functions/array_construct below:

Website Navigation

• Reference
• Function and stored procedure reference
• Semi-structured and structured data

ARRAY_CONSTRUCT | Snowflake Documentation

Categories:

Semi-structured and structured data functions (Array/Object)

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

For more information about constructing and using arrays, see ARRAY.

See also:

ARRAY_CONSTRUCT_COMPACT

ARRAY_CONSTRUCT( [ <expr1> ] [ , <expr2> [ , ... ] ] )

Copy

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

The data type of the returned value is ARRAY.

• If the function is called with N arguments, the size of the resulting array is N.

• In many contexts, you can use an ARRAY constant (also called an ARRAY literal) instead of the ARRAY_CONSTRUCT function.

• An array can contain both SQL NULL values and JSON null values. For more information, see NULL values.

Construct a basic array consisting of numeric data types:

SELECT ARRAY_CONSTRUCT(10, 20, 30);

Copy

+-----------------------------+
| ARRAY_CONSTRUCT(10, 20, 30) |
|-----------------------------|
| [                           |
|   10,                       |
|   20,                       |
|   30                        |
| ]                           |
+-----------------------------+

Construct a basic array consisting of different data types, including a SQL NULL value (undefined) and a JSON null value (null):

SELECT ARRAY_CONSTRUCT(NULL, PARSE_JSON('null'), 'hello', 3::DOUBLE, 4, 5);

Copy

+---------------------------------------------------------------------+
| ARRAY_CONSTRUCT(NULL, PARSE_JSON('NULL'), 'HELLO', 3::DOUBLE, 4, 5) |
|---------------------------------------------------------------------|
| [                                                                   |
|   undefined,                                                        |
|   null,                                                             |
|   "hello",                                                          |
|   3.000000000000000e+00,                                            |
|   4,                                                                |
|   5                                                                 |
| ]                                                                   |
+---------------------------------------------------------------------+

Construct an empty array:

SELECT ARRAY_CONSTRUCT();

Copy

+-------------------+
| ARRAY_CONSTRUCT() |
|-------------------|
| []                |
+-------------------+

Create a table and insert arrays into an ARRAY column:

CREATE OR REPLACE TABLE construct_array_example (id INT, array_column ARRAY);

INSERT INTO construct_array_example (id, array_column)
  SELECT 1,
         ARRAY_CONSTRUCT(1, 2, 3);

INSERT INTO construct_array_example (id, array_column)
  SELECT 2,
         ARRAY_CONSTRUCT(4, 5, 6);

INSERT INTO construct_array_example (id, array_column)
  SELECT 3,
         ARRAY_CONSTRUCT(7, 8, 9);

SELECT * FROM construct_array_example;

Copy

+----+--------------+
| ID | ARRAY_COLUMN |
|----+--------------|
|  1 | [            |
|    |   1,         |
|    |   2,         |
|    |   3          |
|    | ]            |
|  2 | [            |
|    |   4,         |
|    |   5,         |
|    |   6          |
|    | ]            |
|  3 | [            |
|    |   7,         |
|    |   8,         |
|    |   9          |
|    | ]            |
+----+--------------+

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4