Pavel Stehule <pavel.steh...@gmail.com> writes:
>> I know that postgresql array implementation is not right complete and that
>> if just
>> one element of array is NULL the basics array function (array_dims,
>> array_upper, etc.) returns NULL.
> It's not true. Dimensions are stored independent to content.
I wonder if the OP is using an old version of Postgres. Since 8.2 we
can handle null elements of arrays, but 8.1 and older couldn't --- the
whole array went to null if you tried to include a null in it.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
