Обсуждение: Return cursor

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.
/****************************************************************************/

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

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.
>
/***************************************************************************
*/