John R Pierce <pierce@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