Pavel Stehule <pavel.stehule@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
