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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
