pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Correct 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>
  2001-06-21 16:15 ` Re: Correct syntex for implicit curor in for loops Jan Wieck <JanWieck@Yahoo.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 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   ` Re: Correct syntex for implicit curor in for loops Josh Berkus <josh@agliodbs.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 15:43 Correct syntex for implicit curor in for loops Najm Hashmi <najm@mondo-live.com>
  2001-06-21 16:15 ` Re: Correct syntex for implicit curor in for loops Jan Wieck <JanWieck@Yahoo.com>
@ 2001-06-21 16:46   ` Josh Berkus <josh@agliodbs.com>
  2001-06-21 17:35     ` Re: Correct syntex for implicit curor in for loops 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 15:43 Correct syntex for implicit curor in for loops Najm Hashmi <najm@mondo-live.com>
  2001-06-21 16:15 ` Re: Correct syntex for implicit curor in for loops Jan Wieck <JanWieck@Yahoo.com>
  2001-06-21 16:46   ` Re: Correct syntex for implicit curor in for loops Josh Berkus <josh@agliodbs.com>
@ 2001-06-21 17:35     ` Jan Wieck <JanWieck@Yahoo.com>
  2001-06-21 17:54       ` Re: Correct syntex for implicit curor in for loops Tom Lane <tgl@sss.pgh.pa.us>
  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 15:43 Correct syntex for implicit curor in for loops Najm Hashmi <najm@mondo-live.com>
  2001-06-21 16:15 ` Re: Correct syntex for implicit curor in for loops Jan Wieck <JanWieck@Yahoo.com>
  2001-06-21 16:46   ` Re: Correct syntex for implicit curor in for loops Josh Berkus <josh@agliodbs.com>
  2001-06-21 17:35     ` Re: Correct syntex for implicit curor in for loops Jan Wieck <JanWieck@Yahoo.com>
@ 2001-06-21 17:54       ` Tom Lane <tgl@sss.pgh.pa.us>
  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