Array Column Select « Array « PostgreSQL

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