DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=hT3YJeBoTfoWHXbrmPBDtCH8YoCnntMgWcPNpdXQHzMtMTiE/itCvUcXNSnNR4rlks
	+HGokrDtLQWNjRo1hoV/J2U7tvemmZ9+E5JYbjufegEo71W6RHXZN0ntw0wYvJ8JrUzq
	41ZXmPhUf9cWHBD8tNxPmRVk15BBnnpNwGSbs=
MIME-Version: 1.0
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>
Date: Tue, 7 Apr 2009 15:24:23 -0400
Message-ID: <b42b73150904071224i40caed89w1da7394c072ef9ec@mail.gmail.com>
Subject: Re: plpgsql arrays
From: Merlin Moncure <mmoncure@gmail.com>
To: Matthew Wakeling <matthew@flymine.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Apr 7, 2009 at 11:18 AM, Matthew Wakeling <matthew@flymine.org> wro=
te:
> 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? =A0In 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