pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCorrect syntex for implicit curor in for loops
5+ messages / 4 participants
[nested] [flat]
* Correct syntex for implicit curor in for loops
@ 2001-06-21 15:43 Najm Hashmi <najm@mondo-live.com>
0 siblings, 1 reply; 5+ messages in thread
From: Najm Hashmi @ 2001-06-21 15:43 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Correct syntex for implicit curor in for loops
@ 2001-06-21 16:15 Jan Wieck <JanWieck@Yahoo.com>
parent: Najm Hashmi <najm@mondo-live.com>
0 siblings, 1 reply; 5+ messages in thread
From: Jan Wieck @ 2001-06-21 16:15 UTC (permalink / raw)
To: Najm Hashmi <najm@mondo-live.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Correct syntex for implicit curor in for loops
@ 2001-06-21 16:46 Josh Berkus <josh@agliodbs.com>
parent: Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Josh Berkus @ 2001-06-21 16:46 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Correct syntex for implicit curor in for loops
@ 2001-06-21 17:35 Jan Wieck <JanWieck@Yahoo.com>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Jan Wieck @ 2001-06-21 17:35 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: Jan Wieck <JanWieck@Yahoo.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Correct syntex for implicit curor in for loops
@ 2001-06-21 17:54 Tom Lane <tgl@sss.pgh.pa.us>
parent: Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2001-06-21 17:54 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: Josh Berkus <josh@agliodbs.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-06-21 17:54 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-21 15:43 Correct syntex for implicit curor in for loops Najm Hashmi <najm@mondo-live.com>
2001-06-21 16:15 ` Jan Wieck <JanWieck@Yahoo.com>
2001-06-21 16:46 ` Josh Berkus <josh@agliodbs.com>
2001-06-21 17:35 ` Jan Wieck <JanWieck@Yahoo.com>
2001-06-21 17:54 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox