Zitat aus dem Handbuch (http://www.postgresql.org/docs/8.4/static/arrays.html)

Zitat von
The fine manual The current implementation does not enforce the declared number of dimensions either. Arrays of a particular element type are all considered to be of the same type, regardless of size or number of dimensions
Und ein Stückchen weiter steht dann auch wie man das verwendet:
http://www.postgresql.org/docs/8.4/static/arrays.html#ARRAYS-INPUT
Code:
postgres=> CREATE TABLE abc (bla integer[][]);
CREATE TABLE
thomas=> insert into abc values ('{ {1,2},{3,4} }');
INSERT 0 1
thomas=> select * from abc;
bla
---------------
{{1,2},{3,4}}
(1 row)
Lesezeichen