Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4SCfaA98216 for ; Mon, 28 May 2001 08:41:36 -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 f4NNRmA15643; Wed, 23 May 2001 19:27:48 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4NNHZV20775; Wed, 23 May 2001 19:17:35 -0400 (EDT) (envelope-from news) From: Alexander Dederer X-Newsgroups: comp.databases.postgresql.sql, comp.databases.postgresql.general, comp.databases.postgresql.questions Subject: Re: Return cursor Followup-To: comp.databases.postgresql.sql Date: Thu, 24 May 2001 03:19:44 +0400 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 17 Message-ID: <9ehged$k4f$1@news.tht.net> References: <9275d56e.0105231020.6bc24751@posting.google.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: scrappy@hub.org User-Agent: KNode/0.4 To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200105/1091 X-Sequence-Number: 10092 Can you send PL/SQL code and back-end code used this PL/SQL code? Myself trubles with CURSOR I resolve use LIMIT ... OFFSET ... Alla wrote: > 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