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