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@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