Mega Code Archive

 

Categories / PostgreSQL / 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=#