RE: PL/pgSQL CURSOR support

>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
>