ARRAY_PUSHFRONT
Description
Add value to the beginning of the array
Syntax
ARRAY_PUSHFRONT(<arr>, <value>)Parameters
| Parameter | Description |
|---|---|
<arr> | Corresponding array |
<value> | Value to be added |
Return Value
Returns the array after adding value
Example
SELECT ARRAY_PUSHFRONT([1, 2], 3),ARRAY_PUSHFRONT([3, 4], 6);+----------------------------+----------------------------+
| array_pushfront([1, 2], 3) | array_pushfront([3, 4], 6) |
+----------------------------+----------------------------+
| [3, 1, 2] | [6, 3, 4] |
+----------------------------+----------------------------+