Using two dimension array : Array Column Select « Array « PostgreSQL






  1. PostgreSQL
  2. Array
  3. Array Column Select

Using two dimension array


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

postgres=#








Related examples in the same category

1.Use array constant in select statement
2.Selecting entire array values
3.Selecting array values with subscripts
4.Select array column by index
5.Selecting From a Multi-Dimensional Array
6.Accessing two dimensional Arrays
7.Reference array element
8.Searching in Arrays
9.Array Input and Output Syntax
10.SELECT ARRAY[1,2] || ARRAY[[3,4]] AS array
11.Specify non-default array subscripts in an array literal