John R Pierce <pie...@hogranch.com> writes:
> hmmm. array[]::integer[] is an empty array, {}, eg an array with
> zero elements
> but array_length(array[]::integer[]) is NULL rather than zero. this
> seems counterintuitive.
IIRC, there are a whole bunch of questionable behaviors around empty
arrays. Somebody should go through the whole list of array-related
functions and come up with a coherent proposal for fixing all of them.
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
