Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4SCgcA98622 for ; Mon, 28 May 2001 08:42:38 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4OARnA72969; Thu, 24 May 2001 06:27:49 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4OAMhJ29788; Thu, 24 May 2001 06:22:43 -0400 (EDT) (envelope-from news) From: "Sergey E. Volkov" X-Newsgroups: comp.databases.postgresql.sql, comp.databases.postgresql.general, comp.databases.postgresql.questions Subject: Re: Return cursor Date: Thu, 24 May 2001 13:39:54 +0400 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 43 Message-ID: <9eindi$t2p$1@news.tht.net> References: <9275d56e.0105231020.6bc24751@posting.google.com> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200105/1086 X-Sequence-Number: 10083 Hi Alla, "Alla" ???????/???????? ? ???????? ?????????: news:9275d56e.0105231020.6bc24751@posting.google.com... > I am porting our database from Oracle to PostgreSQL > > I know quite a lot about Oracle and pretty much nothing about > PostgreSQL :-)) > > I have a lot of stored procedures in Oracle that return result sets or > cursor. All I have to do there is open a cursor and calling > application can just fetch it Hmm ... As I know ( fix mee ) Oracle's functions ( procedures ) never return result sets but ref cursor. > > Is there anyway to do the same thing in PostgreSQL? PostgreSQL doesn't allow to return cursors from stored procedures. If you want to deal with cursor, just open it in your application. ( See manuals for syntax ) > > Please, help. So far I could not find anything > > Thanks a lot in advance for any help you can provide > > > /*************************************************************************** */ > Alla Gribov > alla@sergey.com > The greatest programming project of all took six days. On the seventh > day the programmer rested. We've been trying to debug the thing ever > since. Moral: design before you implement. > /*************************************************************************** */