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.