From: Merlin Moncure <mmoncure@gmail.com>
To: Matthew Wakeling <matthew@flymine.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: plpgsql arrays
Date: Tue, 7 Apr 2009 15:24:23 -0400
Message-ID: <b42b73150904071224i40caed89w1da7394c072ef9ec@mail.gmail.com> (raw)
In-Reply-To: <alpine.DEB.2.00.0904071616350.791@aragorn.flymine.org>
References: <alpine.DEB.2.00.0904031420470.21772@aragorn.flymine.org>
<28757.1238767715@sss.pgh.pa.us>
<alpine.DEB.2.00.0904071616350.791@aragorn.flymine.org>
On Tue, Apr 7, 2009 at 11:18 AM, Matthew Wakeling <matthew@flymine.org> wrote:
> On Fri, 3 Apr 2009, Tom Lane wrote:
>>>
>>> ... alternatively is there a way to read two results streams
>>> simultaneously?
>>
>> Use two cursors and FETCH from each as needed? In recent releases you
>> can even scroll backwards, which you're going to need to do to make
>> a merge join work.
>
> 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,
Examples:
FETCH curs1 INTO rowvar;
FETCH curs2 INTO foo, bar, baz;
FETCH LAST FROM curs3 INTO x, y;
FETCH RELATIVE -2 FROM curs4 INTO x;
http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html#PLPGSQL-CURSOR-USING
merlin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, matthew@flymine.org, tgl@sss.pgh.pa.us
Subject: Re: plpgsql arrays
In-Reply-To: <b42b73150904071224i40caed89w1da7394c072ef9ec@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox