Re: space taken by NULL values in array

  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.