Re: PL/pgSQL CURSOR support

So FOR is standard ANSI, and IS is Oracle, and we went with Oracle.
Should we allow both?

> Bruce Momjian wrote:
> >
> > Can someone comment on the use of FOR/IS in cursors?
> >
>
> DECLARE <name> CURSOR IS <select_stmt> is the Oracle PL/SQL
> syntax. Since PL/pgSQL was written from the start with one
> eye on portability from/to Oracle, I'd like to stick with
> that.
>
> It's relatively simple to just substitute all PLpgSQL (and
> other case combos) occurences by something else, then replace
> the gram.y and scan.l files with whatever you want and voila,
> you come up with another procedural language as compatible as
> possible to your formerly preferred database. There is no
> reason other than that we'll have more PL handlers to
> support, why we shouldn't have two or three different
> procedural SQL dialects. All can coexist and only those used
> in your DB schema will get loaded.
>
>
> Jan
>
> --
>
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #================================================== JanWieck(at)Yahoo(dot)com #
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026