Re: Dumping rows into an array?

On Wed, Mar 15, 2006 at 09:52:48AM -0500, Tom Lane wrote:
> karly(at)kipshouse(dot)org writes:
> > I've been unable to come up with the counterpart to select the
> > keywords and populate an array that I can return..
>
> I think you want something along the lines of
>
> kwlist := array(select keyword from keywords where ...);
>
> regards, tom lane

Thanks for the reply.

I thought I had tried this, and I had tried something similar, but
for some reason I was using the syntax

ARRAY[(SELECT ...)]

which didn't work. I'll have to go read Section 8.10 again.

Thanks for the help. Now on to my next bug. {-;

-karl