Re: array_length of an empty array - Mailing list pgsql-general

On Sun, Jul 29, 2012 at 01:03:04AM -0700, John R Pierce wrote:
> 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.

It also seems to disagree with the standard:
> 1) An <empty specification> specifies a collection whose cardinality
> is zero.

-Ryan Kelly