Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 6CF0E4761D3
	for <pgsql-sql@postgresql.org>; Wed, 23 Oct 2002 13:21:19 -0400 (EDT)
Received: from web80312.mail.yahoo.com (web80312.mail.yahoo.com
 [66.218.79.28])
	by postgresql.org (Postfix) with SMTP id E4479476135
	for <pgsql-sql@postgresql.org>; Wed, 23 Oct 2002 13:21:18 -0400 (EDT)
Message-ID: <20021023172118.20960.qmail@web80312.mail.yahoo.com>
Received: from [203.87.150.116] by web80312.mail.yahoo.com via HTTP;
	Wed, 23 Oct 2002 10:21:18 PDT
Date: Wed, 23 Oct 2002 10:21:18 -0700 (PDT)
From: Ludwig Lim <lud_nowhere_man@yahoo.com>
Subject: plpgsql cursors : dynamic or static?
To: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/305
X-Sequence-Number: 10022

Hi:

  Are cursors in plpgsql dynamic or static?

  For example :

  ... /* some code */
  FOR rec in   SELECT f1,f2 
               FROM table1 WHERE .... LOOP

    /* some codes that manipulate table1 */
  END LOOP;

  Do the result set pointed to by the cursor remains
the same even if performed some data manipulation
inside the FOR..LOOP?

Thank you in advance,

ludwig.



__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com