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

Categories: Semi-Structured Data

ARRAY_CAT

Returns a concatenation of two arrays.

Syntax​

ARRAY_CAT(arr1 LIST, arr2 LIST) → list​

  • arr1: The source array.
  • arr2: The array to be appended to the source array.

Examples

ARRAY_CAT example 
SELECT ARRAY_CAT(ARRAY[1, 2, 3], ARRAY[4, 5, 6])
-- [1, 2, 3, 4, 5, 6]