Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4SCeMA97631 for ; Mon, 28 May 2001 08:40:22 -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 f4NIRjA03223; Wed, 23 May 2001 14:27:45 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4NIKqH16623; Wed, 23 May 2001 14:20:52 -0400 (EDT) (envelope-from news) From: alla@sergey.com (Alla) X-Newsgroups: comp.databases.postgresql.sql, comp.databases.postgresql.general, comp.databases.postgresql.questions Subject: Return cursor Date: 23 May 2001 11:20:14 -0700 Organization: http://groups.google.com/ Lines: 23 Message-ID: <9275d56e.0105231020.6bc24751@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-support@google.com To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200105/1091 X-Sequence-Number: 10123 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 Is there anyway to do the same thing in PostgreSQL? 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. /****************************************************************************/