Re: Dumping rows into an array?

karly@xxxxxxxxxxxxx · Wed, 15 Mar 2006 10:53:06 -0800

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