SELECT ARRAY[1,2] || ARRAY[[3,4]] AS array : Array Column Select « Array « PostgreSQL






  1. PostgreSQL
  2. Array
  3. Array Column Select

SELECT ARRAY[1,2] || ARRAY[[3,4]] AS array


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

postgres=#








Related examples in the same category

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