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

ARRAY_CAT¶

Returns a concatenation of two arrays.

Syntax¶

ARRAY_CAT( <array1> , <array2> ) 

Copy

Arguments¶

array1: The source array.
array2: The array to be appended to array1.

Returns¶

An ARRAY containing the elements from array2 appended after the elements of array1.

Usage notes¶

Both arguments must either be structured ARRAYs or semi-structured ARRAYs.

If you are passing in semi-structured ARRAYs, both arguments must be of ARRAY type or VARIANT containing an array.
If you are passing in structured ARRAYs, the function returns an ARRAY of a type that can accommodate both input types.
If either argument is NULL, the function returns NULL without reporting any error.

Examples¶

This example shows how to use ARRAY_CAT():

Create a simple table and data:

CREATE TABLE array_demo (ID INTEGER, array1 ARRAY, array2 ARRAY); 

Copy

INSERT INTO array_demo (ID, array1, array2) SELECT 1, ARRAY_CONSTRUCT(1, 2), ARRAY_CONSTRUCT(3, 4); 

Copy

Execute the query:

SELECT ARRAY_CAT(array1, array2) FROM array_demo; +---------------------------+ | ARRAY_CAT(ARRAY1, ARRAY2) | |---------------------------| | [ | | 1, | | 2, | | 3, | | 4 | | ] | +---------------------------+ 

Copy