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.com
PostgreSQL Training, Services and Support