Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
Description
ARRAY_APPEND - adds element to the end of the array and returns the resulting array
ARRAY_PREPEND - adds element to the beginning of the array and returns the resulting array
Syntax:
ARRAY_APPEND( <array> , <new_element> ); ARRAY_PREPEND( <new_element> , <array> );
Arguments:
array: An ARRAY to to add a new element.
new_element: A new element.
Returns:
An array. If array is NULL, the result is NULL.
Examples:
SELECT array_append(array[1, 2, 3], 4); -- array[1, 2, 3, 4] select array_append(cast(null as int array), 2); -- null SELECT array_prepend(4, array[1, 2, 3]); -- array[4, 1, 2, 3] SELECT array_prepend(null, array[1, 2, 3]); -- array[null, 1, 2, 3]
See more:
ARRAY_APPEND
Snowflake https://docs.snowflake.com/en/sql-reference/functions/array_append.html
PostgreSQL https://www.postgresql.org/docs/14/functions-array.html#ARRAY-FUNCTIONS-TABLE
ARRAY_PREPEND
Snowflake https://docs.snowflake.com/en/sql-reference/functions/array_prepend.html
PostgreSQL https://www.postgresql.org/docs/14/functions-array.html#ARRAY-FUNCTIONS-TABLE
Attachments
Issue Links
- links to