Re: Dumping rows into an array?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: karly(at)kipshouse(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dumping rows into an array?
Date: 2006-03-15 14:52:48
Message-ID: 20289.1142434368@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-15 15:07:09 Re: Inserting in psql - invalid byte sequence for encoding "UNICODE": 0xe9
Previous Message Linda 2006-03-15 14:39:13 Re: question about postgresql time intervals