>       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

Reply via email to