Skip to main content
Version: current [25.x]

Categories: Semi-Structured Data

ARRAY_APPEND

Appends an element to the end of an array.

Syntax​

ARRAY_APPEND(array LIST, element ANY) → LIST​

  • array: The array to append to.
  • element: The element to append to the array.

Examples

ARRAY_APPEND example 
SELECT ARRAY_APPEND(ARRAY[1, 2], 3);
-- [1, 2, 3]