From: | "Sergey E(dot) Volkov" <sve(at)raiden(dot)bancorp(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PL/pgSQL CURSOR support |
Date: | 2001-05-22 09:54:22 |
Message-ID: | 9edf1j$2fpb$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Definitely it's Oracle's syntax.
"Zeugswetter Andreas SB " <ZeugswetterA(at)wien(dot)spardat(dot)at> /
:
news:11C1E6749A55D411A9670001FA6879633682EA(at)sdexcsrv1(dot)f000(dot)d0188(dot)sd(dot)spardat(dot)
at...
>
> > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-05-22 11:13:24 | Re: DROP CONSTRAINT patch |
Previous Message | Zeugswetter Andreas SB | 2001-05-22 09:32:40 | AW: PL/pgSQL CURSOR support |