Selecting From a Multi-Dimensional Array : Array Column Select « Array « PostgreSQL






  1. PostgreSQL
  2. Array
  3. Array Column Select

Selecting From a Multi-Dimensional Array


postgres=#
postgres=# CREATE TABLE authors (id integer,titles text[][]);
CREATE TABLE
postgres=#
postgres=# INSERT INTO authors
postgres-#              VALUES (102,
postgres(#              '{{"J T", "T S"},
postgres'#                {"C D", "G E"},
postgres'#                {"A D", "A L"}}');
INSERT 0 1
postgres=#
postgres=# -- Selecting From a Multi-Dimensional Array
postgres=#
postgres=# SELECT titles[1][1] AS author, titles[1][2] AS title FROM authors;
 author | title
--------+-------
 J T    | T S
(1 row)

postgres=#
postgres=# drop table authors;
DROP TABLE
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.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