Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com [216.136.173.31]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5LG9ta47214 for ; Thu, 21 Jun 2001 12:09:55 -0400 (EDT) (envelope-from janwieck@yahoo.com) Received: from jupiter.us.greatbridge.com (65.196.69.55) by smtp.mail.vip.sc5.yahoo.com with SMTP; 21 Jun 2001 16:09:54 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f5LGFvO02309; Thu, 21 Jun 2001 12:15:57 -0400 From: Jan Wieck Message-Id: <200106211615.f5LGFvO02309@jupiter.us.greatbridge.com> Subject: Re: Correct syntex for implicit curor in for loops In-Reply-To: <3B32160F.6A35893E@mondo-live.com> from Najm Hashmi at "Jun 21, 2001 11:43:12 am" To: Najm Hashmi Date: Thu, 21 Jun 2001 12:15:57 -0400 (EDT) CC: pgsql X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/332 X-Sequence-Number: 3619 Najm Hashmi wrote: > Hi All, Could someone please tell me the Correct syntex for implicit > curor in FOR loops > Thank you in advance. If you're talking about the PL/pgSQL procedural language, there is no (implicit or explicit) cursor support up to version 7.1. From version 7.2 on PL/pgSQL will automatically use implicit cursors in FOR loops and will support explicit cursors and reference cursors that can be passed around between functions and/or the main application. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com