On 09/20/10 1:24 AM, Leonardo Francalanci wrote:
i thought PG multidimensional arrays were just arrays of arrays, and any
dimension could be anything.
from:
http://www.postgresql.org/docs/8.4/static/arrays.html
"Multidimensional arrays must have matching extents for each dimension. A
mismatch causes an error"
maybe thats poorly worded.
the example of that error shows an array with 2 columns in the first row
and 1 column in the 2nd row.
'{{"meeting", "lunch"}, {"meeting"}}'
thats not a valid array.
'{{"meeting", "lunch"}, {"training", "presentation"}}'
is a valid array.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
