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

From David E. Wheeler
Subject Re: So what's an "empty" array anyway?
Date
Msg-id 47938F22-E981-451A-BC9C-AA61907B06B5@kineticode.com
Whole thread Raw
In response to Re: So what's an "empty" array anyway?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: So what's an "empty" array anyway?
Re: So what's an "empty" array anyway?
Re: So what's an "empty" array anyway?
List pgsql-hackers
On Oct 21, 2008, at 13:58, Tom Lane wrote:

>> If we got rid of zero dimension arrays, how would I declare a new
>> empty array in a PL/pgSQL function?
>
> 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.

Best,

David



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: So what's an "empty" array anyway?
Next
From: Josh Berkus
Date:
Subject: Re: So what's an "empty" array anyway?