Postgres Pro
Downloads
Home   >   mailing lists

Re: About the behavior of array_length() for empty array - Mailing list pgsql-hackers

From Robert Haas
Subject Re: About the behavior of array_length() for empty array
Date
Msg-id CA+Tgmob29VhwqYmnP3dHp=OCHeP37Cxovv0LsOvT99qQHO6y2g@mail.gmail.com
Whole thread Raw
In response to About the behavior of array_length() for empty array  ("iihero" <iihero@qq.com>)
List pgsql-hackers
Tree view 
On Thu, Apr 5, 2012 at 8:35 PM, iihero <iihero@qq.com> wrote:
> From this point of view, seems N dimensions of empty array all are
> equivalent.

Yes.  It's effectively viewed as a 0-dimensional array.

> Is there standard definition of this behavior?

No.  Multi-dimensional arrays are a PostgreSQL extension.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Deprecating non-select rules (was Re: Last gasp)
Next
From: Tom Lane
Date:
Subject: Re: Potential for bugs while using COPY_POINTER_FIELD to copy NULL pointer