Re: Should array_length() Return NULL - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Should array_length() Return NULL
Date
Msg-id 8DED33E2-D3D2-450C-BB49-7A31D449F223@justatheory.com
Whole thread Raw
In response to Re: Should array_length() Return NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mar 16, 2013, at 11:19 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Perhaps not.  I think for most uses, a 1-D zero-length array would be
> just as good.  I guess what I'd want to know is whether we also need
> to support higher-dimensional zero-size arrays, and if so, what does
> the I/O syntax for those look like?

No.

> Another fly in the ointment is that if we do redefine '{}' as meaning
> something other than a zero-D array, how will we handle existing
> database entries that are zero-D arrays?

NULL. About as useful. ;-P

David


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Should array_length() Return NULL
Next
From: Stephen Frost
Date:
Subject: Re: Strange Windows problem, lock_timeout test request