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(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)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
>