From najm@mondo-live.com Thu Jun 21 15:43:31 2001 Received: from najm.local2.lan ([216.221.221.2]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LFhVa34640 for ; Thu, 21 Jun 2001 11:43:31 -0400 (EDT) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@localhost.localdomain [127.0.0.1]) by najm.local2.lan (8.9.3/8.9.3) with ESMTP id LAA04333 for ; Thu, 21 Jun 2001 11:43:12 -0400 Message-ID: <3B32160F.6A35893E@mondo-live.com> Date: Thu, 21 Jun 2001 11:43:12 -0400 From: Najm Hashmi X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql Subject: Correct syntex for implicit curor in for loops Content-Type: multipart/alternative; boundary="------------6EC616557C869B52203694CC" X-Archive-Number: 200106/331 X-Sequence-Number: 3618 --------------6EC616557C869B52203694CC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi All, Could someone please tell me the Correct syntex for implicit curor in FOR loops Thank you in advance. -- Najm Hashmi Tel:514-271-9791 www.mondo-live.com www.flipr.com --------------6EC616557C869B52203694CC Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi All, Could someone  please tell me the Correct syntex for implicit curor in FOR loops
Thank  you in advance.
-- 
Najm Hashmi
Tel:514-271-9791
www.mondo-live.com
www.flipr.com
  --------------6EC616557C869B52203694CC-- From JanWieck@Yahoo.com Thu Jun 21 16:09:55 2001 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 From josh@agliodbs.com Thu Jun 21 16:46:37 2001 Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LGkba63012 for ; Thu, 21 Jun 2001 12:46:37 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 75363; Thu, 21 Jun 2001 09:46:36 -0700 From: "Josh Berkus" Subject: Re: Correct syntex for implicit curor in for loops To: Jan Wieck Cc: pgsql X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Thu, 21 Jun 2001 09:46:36 -0700 Message-ID: In-Reply-To: <200106211615.f5LGFvO02309@jupiter.us.greatbridge.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/333 X-Sequence-Number: 3620 Jan, > 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. ALL RIGHT!!! Sorry, just a bit of unrestrained enthusiasm. Is there a tentative timeline for 7.2? -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco From JanWieck@Yahoo.com Thu Jun 21 17:29:31 2001 Received: from smtp010.mail.yahoo.com (smtp010.mail.yahoo.com [216.136.173.30]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5LHTVa81329 for ; Thu, 21 Jun 2001 13:29:31 -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 17:29:29 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f5LHZap02411; Thu, 21 Jun 2001 13:35:36 -0400 From: Jan Wieck Message-Id: <200106211735.f5LHZap02411@jupiter.us.greatbridge.com> Subject: Re: Correct syntex for implicit curor in for loops In-Reply-To: from Josh Berkus at "Jun 21, 2001 09:46:36 am" To: Josh Berkus Date: Thu, 21 Jun 2001 13:35:35 -0400 (EDT) CC: Jan Wieck , 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/335 X-Sequence-Number: 3622 Josh Berkus wrote: > Jan, > > > 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. > > ALL RIGHT!!! > > Sorry, just a bit of unrestrained enthusiasm. > > Is there a tentative timeline for 7.2? With our last closeness of the real release date vs. the first estimations, and we don't even have a proposal up to now - well, maybe this or next year is the most precise I can tell you ;-} 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 From tgl@sss.pgh.pa.us Thu Jun 21 17:54:11 2001 Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LHsBa92419 for ; Thu, 21 Jun 2001 13:54:11 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f5LHs3322209; Thu, 21 Jun 2001 13:54:03 -0400 (EDT) To: Jan Wieck cc: Josh Berkus , pgsql Subject: Re: Correct syntex for implicit curor in for loops In-reply-to: <200106211735.f5LHZap02411@jupiter.us.greatbridge.com> References: <200106211735.f5LHZap02411@jupiter.us.greatbridge.com> Comments: In-reply-to Jan Wieck message dated "Thu, 21 Jun 2001 13:35:35 -0400" Date: Thu, 21 Jun 2001 13:54:02 -0400 Message-ID: <22206.993146042@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/338 X-Sequence-Number: 3625 Jan Wieck writes: >> Is there a tentative timeline for 7.2? > With our last closeness of the real release date vs. the > first estimations, and we don't even have a proposal up to > now - well, maybe this or next year is the most precise I can > tell you ;-} The problem last time was we'd decided that 7.1 would have WAL, and WAL took forever, and we weren't in a position to back off and make a release without it. This cycle we don't have any comparable huge must-do projects. I'm inclined to plan a 7.2 release cycle for late summer and release with whatever's done by then. Anything that's not ready will just have to wait for the next bus. regards, tom lane