> 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 ?
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 ?
Andreas
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl