Received: from smtp-server1.tampabay.rr.com (smtp-server1.tampabay.rr.com
	[65.32.1.34]) by postgresql.org (Postfix) with ESMTP
	id 42048475CE4; Thu, 11 Jul 2002 19:24:39 -0400 (EDT)
Received: from [192.168.0.2] (47.80.35.65.cfl.rr.com [65.35.80.47])
	by smtp-server1.tampabay.rr.com (8.12.2/8.12.2) with ESMTP id
	g6BNOfo0005349; Thu, 11 Jul 2002 19:24:41 -0400 (EDT)
Message-Id: <200207112324.g6BNOfo0005349@smtp-server1.tampabay.rr.com>
Date: Thu, 11 Jul 2002 19:24:41 -0400
From: Jim Parker <hopeye@cfl.rr.com>
To: pgsql-interfaces@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Can I have multiple cursors open ...
Reply-To: hopeye@cfl.rr.com
In-Reply-To: <3D2E069F.AB7A5169@Yahoo.com>
References: <HKEIIDPFPDBMOMDLIEEGIEEFCJAA.iavor.raytchev@verysmall.org>
	<3D2E069F.AB7A5169@Yahoo.com>
X-Mailer: Spruce 0.7.4 for X11 w/smtpio 0.8.2
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200207/65
X-Sequence-Number: 2874

.. inside of each other using ECPG ?

I have a situation where it would be advantages to open a cursor, retrieve
a tuple, then open another query based on the results of the first.  Then
when that query has been processed return to the first query and get the
second tuple.

Is this possible ?

cheers,
Jim Parker