Concatenate two arrays : Concatenate Array « Array « PostgreSQL






  1. PostgreSQL
  2. Array
  3. Concatenate Array

Concatenate two arrays



postgres=#
postgres=#
postgres=# SELECT ARRAY[1,2] || ARRAY[3,4];
 ?column?
-----------
 {1,2,3,4}
(1 row)

postgres=#








Related examples in the same category

1.Concatenate two dimensional arrays
2.array_dims(1 || ARRAY[2,3])
3.array_dims(ARRAY[1,2] || 3)
4.array_dims(ARRAY[1,2] || ARRAY[3,4,5])
5.array_dims(ARRAY[[1,2],[3,4]] || ARRAY[[5,6],[7,8],[9,0]])
6.array_dims(ARRAY[1,2] || ARRAY[[3,4],[5,6]])