Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7F8D8475CCE
	for <pgsql-sql@postgresql.org>; Thu, 12 Sep 2002 14:10:28 -0400 (EDT)
Received: from hotmail.com (dav37.law15.hotmail.com [64.4.22.94])
	by postgresql.org (Postfix) with ESMTP id B94A4475BEC
	for <pgsql-sql@postgresql.org>; Thu, 12 Sep 2002 14:10:27 -0400 (EDT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Thu, 12 Sep 2002 11:10:27 -0700
X-Originating-IP: [204.244.28.188]
From: "david williams" <dw_remote@hotmail.com>
To: <pgsql-sql@postgresql.org>
Subject: Returning a reference to a cursor from a function
Date: Thu, 12 Sep 2002 14:12:37 -0400
MIME-Version: 1.0
X-Mailer: MSN Explorer 7.00.0021.1900
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_0002_01C25A66.729533E0"
Message-ID: <DAV374EsURKQaJcrJf00000cd8c@hotmail.com>
X-OriginalArrivalTime: 12 Sep 2002 18:10:27.0951 (UTC)
	FILETIME=[AC6A07F0:01C25A87]
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/163
X-Sequence-Number: 9440

------=_NextPart_001_0002_01C25A66.729533E0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

To anyone who can help me,

I am new at Postgresql and am having some problems.

I am trying to return a rowset from a function to the calling procedure.

Outside a function I have gotten this to work at the psql level.

-------------
BEGIN Work;
    DECLARE Liahona CURSOR FOR Select * from users;
FETCH FORWARD ALL IN Liahona;
CLOSE Liahona;
COMMIT Work;
--------------

I went a stage further attempt to put this query into a function as such

--------------
CREATE FUNCTION getallusers() RETURN integer AS'
DECLARE
    Liahona CURSOR FOR Select * from users;
BEGIN

FETCH FORWARD ALL IN Liahona;

CLOSE Liahona;
END;
'language 'plpgsql';

---------------
Followed by 'select getallusers();' for testing purposes.

I get the error:

ERROR during compile of getallusers near line 5
Parse error at or near "FORWARD"

I have tried creating RECORD type cursors but no luck.

Can anyone suggest how to do this.

I was referenced to this this through my discussion at dbforums.com.

http://dbforums.com/t499825.html

Thanks

!-------------------------------------!
David WilliamsGet more from the Web.  FREE MSN Explorer download : http://e=
xplorer.msn.com

------=_NextPart_001_0002_01C25A66.729533E0
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML><BODY STYLE=3D"font:10pt verdana; border:none;"><DIV>To anyone who ca=
n help me,</DIV> <DIV>&nbsp;</DIV> <DIV>I am new at Postgresql and am havin=
g some problems.</DIV> <DIV>&nbsp;</DIV> <DIV>I am trying to return a rowse=
t from a function to the calling procedure.</DIV> <DIV>&nbsp;</DIV> <DIV>Ou=
tside a function I have gotten this to work at the psql level.</DIV> <DIV>&=
nbsp;</DIV> <DIV>-------------</DIV> <DIV>BEGIN&nbsp;Work;</DIV> <DIV>&nbsp=
;&nbsp;&nbsp; DECLARE Liahona CURSOR FOR Select * from users;</DIV> <DIV>FE=
TCH FORWARD ALL IN Liahona;</DIV> <DIV>CLOSE Liahona;</DIV> <DIV>COMMIT Wor=
k;</DIV> <DIV>--------------</DIV> <DIV>&nbsp;</DIV> <DIV>I went a stage fu=
rther attempt to put this query into a function as such</DIV> <DIV>&nbsp;</=
DIV> <DIV>--------------</DIV> <DIV>CREATE FUNCTION getallusers() RETURN in=
teger AS'</DIV> <DIV>DECLARE</DIV> <DIV>&nbsp;&nbsp;&nbsp; Liahona CURSOR F=
OR Select * from users;</DIV> <DIV>BEGIN</DIV> <DIV>&nbsp;</DIV> <DIV>FETCH=
 FORWARD ALL IN Liahona;</DIV> <DIV>&nbsp;</DIV> <DIV>CLOSE Liahona;</DIV> =
<DIV>END;</DIV> <DIV>'language 'plpgsql';</DIV> <DIV>&nbsp;</DIV> <DIV>----=
-----------</DIV> <DIV>Followed by 'select getallusers();' for testing purp=
oses.</DIV> <DIV>&nbsp;</DIV> <DIV>I get the error:</DIV> <DIV>&nbsp;</DIV>=
 <DIV>ERROR during compile of getallusers near line 5</DIV> <DIV>Parse erro=
r at or near "FORWARD"</DIV> <DIV>&nbsp;</DIV> <DIV>I have tried creating R=
ECORD type cursors but no luck.</DIV> <DIV>&nbsp;</DIV> <DIV>Can anyone sug=
gest how to do this.</DIV> <DIV>&nbsp;</DIV> <DIV>I was referenced to this =
this through my discussion at dbforums.com.</DIV> <DIV>&nbsp;</DIV> <DIV><A=
 href=3D"http://dbforums.com/t499825.html">http://dbforums.com/t499825.html=
</A><BR></DIV> <DIV>Thanks</DIV> <DIV><BR>!--------------------------------=
-----!<BR>David Williams</DIV></BODY></HTML><br clear=3Dall><hr>Get more fr=
om the Web.  FREE MSN Explorer download : <a href=3D'http://explorer.msn.co=
m'>http://explorer.msn.com</a><br></p>

------=_NextPart_001_0002_01C25A66.729533E0--