Array Input and Output Syntax : Array Column Select « Array « PostgreSQL






Array Input and Output Syntax


postgres=#
postgres=# -- Array Input and Output Syntax
postgres=# SELECT 1 || ARRAY[2,3] AS array;
     array
---------------
 [0:2]={1,2,3}
(1 row)

postgres=#
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.SELECT ARRAY[1,2] || ARRAY[[3,4]] AS array
11.Specify non-default array subscripts in an array literal