Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1955A476048 for ; Wed, 23 Oct 2002 14:21:53 -0400 (EDT) Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 8060C475D70 for ; Wed, 23 Oct 2002 14:21:52 -0400 (EDT) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1796814; Wed, 23 Oct 2002 11:23:13 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Ludwig Lim , PostgreSQL Mailing List Subject: Re: plpgsql cursors : dynamic or static? Date: Wed, 23 Oct 2002 11:21:00 -0700 X-Mailer: KMail [version 1.4] References: <20021023172118.20960.qmail@web80312.mail.yahoo.com> In-Reply-To: <20021023172118.20960.qmail@web80312.mail.yahoo.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200210231121.00113.josh@agliodbs.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/311 X-Sequence-Number: 10028 Ludwig, > Are cursors in plpgsql dynamic or static? >=20 > For example : >=20 > ... /* some code */ > FOR rec in SELECT f1,f2=20 > FROM table1 WHERE .... LOOP >=20 > /* some codes that manipulate table1 */ > END LOOP; Technically speaking, that is not a cursor, even though it serves the same= =20 purpose. I'm pretty sure it's static, but it would be easy to test ... why don't you= =20 give it a try? --=20 -Josh Berkus Aglio Database Solutions San Francisco