Concatenate two dimensional arrays : Concatenate Array « Array « PostgreSQL






  1. PostgreSQL
  2. Array
  3. Concatenate Array

Concatenate two dimensional arrays


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

postgres=#








Related examples in the same category

1.Concatenate two 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]])