Re: AW: PL/pgSQL CURSOR support

Zeugswetter Andreas SB wrote:
>
> > Explicit cursor can be declared as:
> >
> > DECLARE
> > ...
> > curname CURSOR [(argname type [, ...])]
> > IS <select_stmt>;
>
> In esql you would have FOR instead of IS.
>
> DECLARE curname CURSOR ... FOR ....
>
> Thus the question, where is the syntax from ?

From the worlds most expens\b\b\b\b\b\b - er - reliable
commercial database system.

> There seems to be a standard for "the" SQL stored procedure language:
>
> "Persistent Stored Module definition of the ANSI SQL99 standard" (quote from DB/2)
> Anybody know this ?

The entire PL/pgSQL was written with some compatibility in
mind. Otherwise FOR loops would look more like

[ <<label>> ]
FOR <loop_name> AS
[ EACH ROW OF ] [ CURSOR <cursor_name> FOR ]
<cursor_specification> DO
<statements>
END FOR;

The good thing is that we can have any number of loadable
procedural languages. It's relatively easy to change the
PL/pgSQL parser and create some PL/SQL99 handler. As long as
the symbols in the modules don't conflict, I see no reason
why we shouldn't.

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