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

From Tom Lane
Subject Re: Dumping rows into an array?
Date
Msg-id 20289.1142434368@sss.pgh.pa.us
Whole thread Raw
In response to Dumping rows into an array?  (karly@kipshouse.org)
Responses Re: Dumping rows into an array?  (karly@kipshouse.org)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: tsearch is slow
Next
From: Tom Lane
Date:
Subject: Re: Inserting in psql - invalid byte sequence for encoding "UNICODE": 0xe9