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

From Zeugswetter Andreas SB
Subject AW: PL/pgSQL CURSOR support
Date
Msg-id 11C1E6749A55D411A9670001FA6879633682EA@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: PL/pgSQL CURSOR support  (Jan Wieck <JanWieck@Yahoo.com>)
RE: PL/pgSQL CURSOR support  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
>       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


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: Plans for solving the VACUUM problem
Next
From: Bruce Momjian
Date:
Subject: Re: DROP CONSTRAINT patch