Re: So what's an "empty" array anyway?

On Tue, 2008-10-21 at 14:03 -0700, David E. Wheeler wrote:
> 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.

I meant the dimension of {} should be NULL.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support