Pavel Stehule <pavel.stehule@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