Re: PL/pgSQL CURSOR support

Can someone comment on the use of FOR/IS in cursors?

[ Charset ISO-8859-1 unsupported, converting... ]
> >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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026