Re: PL/pgSQL CURSOR support - Mailing list pgsql-hackers

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@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
> > 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

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