what is wrong with data type 'array' ?
hi, all: When I tried the example from PostgreSQL guide as follows:CREATE
TABLE sal_emp (
name text,
pay_by_quarter integer[],
schedule text[][]
); To my surprised, the table created actually isCREATE TABLE sal_emp (
name text,
pay_by_quarter integer[],
schedule text[]
); I was wondering if PostgreSQL really supports multidimensional array
with more than tow dimensions? jack_dull
"Jack Dull" <jack_dull@sina.com> writes:
); I was wondering if PostgreSQL really supports multidimensional array
with more than tow dimensions?
It does, but they aren't considered a fundamentally different datatype
from single-dimensional arrays. Writing extra '[]' pairs in the CREATE
TABLE is just syntactic sugar.
regards, tom lane