Re: So what's an "empty" array anyway? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: So what's an "empty" array anyway?
Date
Msg-id 9858.1224623789@sss.pgh.pa.us
Whole thread Raw
In response to Re: So what's an "empty" array anyway?  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: So what's an "empty" array anyway?
List pgsql-hackers
"David E. Wheeler" <david@kineticode.com> writes:
> On Oct 21, 2008, at 13:58, Tom Lane wrote:
>> Same as before, I think: initialize it to '{}'.  What's at stake here
>> is exactly what does that notation mean ...

> An empty, single-dimension array. But I got the impression from Simon  
> that he thought it should be NULL.

Well, we can't do that because it would clearly break too much existing
code.  '{}' has got to result in something you can successfully
concatenate more elements to.  But either the current behavior with
a zero-dimension array, or a one-dimensional length-zero array would
presumably work okay.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: So what's an "empty" array anyway?
Next
From: Josh Berkus
Date:
Subject: Re: Bitmap Indexes: request for feedback