ARRAY_POPBACK
description
Remove the last element from array.
Syntax
ARRAY_POPBACK(<arr>)Parameters
| Parameter | Description |
|---|---|
<arr> | ARRAY array |
Return Value
Returns the array after removing the last element. Special cases:
- If the input parameter is NULL, returns NULL.
example
select array_popback(['test', NULL, 'value']);+-----------------------------------------------------+
| array_popback(ARRAY('test', NULL, 'value')) |
+-----------------------------------------------------+
| ["test", NULL] |
+-----------------------------------------------------+