Re: PL/pgSQL CURSOR support

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,
thenreplace   the gram.y and scan.l files with whatever you want and voila,   you come up with another procedural
languageas 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