pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sergey E. Volkov <sve@raiden.bancorp.ru>
To: pgsql-general@postgresql.org.pgsql-sql
Subject: Re: Return cursor
Date: Thu, 24 May 2001 13:39:54 +0400
Message-ID: <9eindi$t2p$1@news.tht.net> (raw)
References: <9275d56e.0105231020.6bc24751@posting.google.com>

Hi Alla,

"Alla" <alla@sergey.com> ???????/???????? ? ???????? ?????????:
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.
>
/***************************************************************************
*/





view thread (6+ messages)  latest in thread

Message-ID: <9eindi$t2p$1@news.tht.net>
Permalink:  ../9eindi$t2p$1@news.tht.net/
Also on:    postgresql.org/message-id/9eindi$t2p$1@news.tht.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sve@raiden.bancorp.ru, pgsql-general@postgresql.org.pgsql-sql
  Subject: Re: Return cursor
  In-Reply-To: <9eindi$t2p$1@news.tht.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox