Re: PL/pgSQL CURSOR support

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

In response to

Browse pgsql-hackers by date

  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