| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | Leonardo Francalanci <m_lists(at)yahoo(dot)it> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: space taken by NULL values in array |
| Date: | 2010-09-20 08:37:50 |
| Message-ID: | 4C971D5E.50608@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrien Kunysz | 2010-09-20 08:57:06 | Re: Getting FATAL: terminating connection due to administrator command |
| Previous Message | Leonardo Francalanci | 2010-09-20 08:24:23 | Re: space taken by NULL values in array |