documentationarray_concat¶
Description¶
Returns a concatenation of the two arrays array1 and array2.
Note that this function appends array2 to array1.
The type of both arguments shall be either ARRAY or a VARIANT containing an array.
Return type¶
array
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
array_concat( lhs, rhs )
Argument |
Type |
Required |
Multiple |
|---|---|---|---|
lhs |
variable |
Required |
Only one |
rhs |
variable |
Required |
Only one |
Examples¶
make_col foo:array_concat(make_array(1, 2), make_array(3))
Creates a column foo with an array that contains [1, 2, 3].
Note that the content of 2nd array is appended after the content of the 1st array.