>From SQL99 (Note: the 'FOR' keyword seems standard...):
14 Data manipulation
14.1 <declare cursor>
Function
Define a cursor.
Format
<declare cursor> ::= DECLARE <cursor name> [ <cursor sensitivity> ] [ <cursor
scrollability>] CURSOR [ <cursor holdability> ] [ <cursor returnability> ]
FOR<cursor specification>
<cursor sensitivity> ::= SENSITIVE | INSENSITIVE | ASENSITIVE
<cursor scrollability> ::= SCROLL | NO SCROLL
<cursor holdability> ::= WITH HOLD | WITHOUT HOLD
<cursor returnability> ::= WITH RETURN | WITHOUT RETURN
<cursor specification> ::= <query expression> [ <order by clause> ] [ <updatability
clause>]
<updatability clause> ::= FOR { READ ONLY | UPDATE [ OF <column name list> ] }
<order by clause> ::= ORDER BY <sort specification list>
<sort specification list> ::= <sort specification> [ { <comma> <sort specification> }... ]
<sort specification> ::= <sort key> [ <collate clause> ] [ <ordering specification> ]
<sort key> ::= <value expression>
<ordering specification> ::= ASC | DESC
Chris
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Zeugswetter
> Andreas SB
> Sent: Tuesday, 22 May 2001 5:33 PM
> To: 'Jan Wieck'; PostgreSQL HACKERS
> Subject: AW: [HACKERS] PL/pgSQL CURSOR support
>
>
>
> > 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
>
