Thread: Correct syntex for implicit curor in for loops
Hi All, Could someone please tell me the Correct syntex for implicit curor in FOR loops <br />Thank you in advance. <pre>-- Najm Hashmi Tel:514-271-9791 www.mondo-live.com www.flipr.com</pre>
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
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 informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
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
Jan Wieck <JanWieck@Yahoo.com> 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