- Categories:
Semi-structured Data Functions (Array/Object)
ARRAY_CATΒΆ
Returns a concatenation of two arrays.
SyntaxΒΆ
ARRAY_CAT( <array1> , <array2> )
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 be of ARRAY type or VARIANT containing an array.
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);INSERT INTO array_demo (ID, array1, array2) SELECT 1, ARRAY_CONSTRUCT(1, 2), ARRAY_CONSTRUCT(3, 4);Execute the query:
SELECT ARRAY_CAT(array1, array2) FROM array_demo; +---------------------------+ | ARRAY_CAT(ARRAY1, ARRAY2) | |---------------------------| | [ | | 1, | | 2, | | 3, | | 4 | | ] | +---------------------------+