Re: array_length of an empty array

From: Ryan Kelly <rpkelly22(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: array_length of an empty array
Date: 2012-07-29 13:55:57
Message-ID: 20120729135557.GA3145@llserver.lakeliving.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-07-29 15:10:01 Re: array_length of an empty array
Previous Message Vincent Veyron 2012-07-29 12:16:43 Re: BI tools and postgresql