Re: Dumping rows into an array? - Mailing list pgsql-general

On Wed, Mar 15, 2006 at 09:52:48AM -0500, Tom Lane wrote:
> karly@kipshouse.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