Use array constant in select statement : Array Column Select « Array « PostgreSQL






  1. PostgreSQL
  2. Array
  3. Array Column Select

Use array constant in select statement

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








Related examples in the same category

1.Using two dimension array
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