| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | Matthew Wakeling <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: plpgsql arrays |
| Date: | 2009-04-07 19:31:55 |
| Message-ID: | 20204.1239132715@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
> On Tue, Apr 7, 2009 at 11:18 AM, Matthew Wakeling <matthew(at)flymine(dot)org> wrote:
>> What would be the syntax for putting a single row from a cursor into a
>> variable? I have tried:
>>
>> FETCH INTO left left_cursor;
> according to the docs,
> http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html#PLPGSQL-CURSOR-USING
Subsequent discussion showed that the problem was Matthew hadn't found
that page. I guess that at least the DECLARE CURSOR reference page
ought to have something like "if you are trying to use cursors in
plpgsql, see <link>". Matthew, where *were* you looking exactly?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2009-04-07 22:49:22 | Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 |
| Previous Message | Merlin Moncure | 2009-04-07 19:24:23 | Re: plpgsql arrays |