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@Yahoo.com #
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026