Skip to main content

ARRAY_PUSHBACK

Description​

Add value to the end of the array

Syntax​

ARRAY_PUSHBACK(<arr>, <value>)

Parameters​

ParameterDescription
<arr>Corresponding array
<value>Value to be added

Return Value​

Returns the array after adding value

Example​

SELECT ARRAY_PUSHBACK([1, 2], 3),ARRAY_PUSHBACK([3, 4], 6);
+---------------------------+---------------------------+
| array_pushback([1, 2], 3) | array_pushback([3, 4], 6) |
+---------------------------+---------------------------+
| [1, 2, 3] | [3, 4, 6] |
+---------------------------+---------------------------+