| From: | Alexander Dederer <dederer(at)spb(dot)cityline(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Return cursor |
| Date: | 2001-05-23 23:19:44 |
| Message-ID: | 9ehged$k4f$1@news.tht.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2001-05-23 23:57:57 | Re: Estimating costs (was Functional Indices) |
| Previous Message | Paul Tomblin | 2001-05-23 22:15:07 | Re: Why can't I do this (setup question) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Peterson | 2001-05-24 03:36:09 | Re: Recursive select |
| Previous Message | Bruno Boettcher | 2001-05-23 22:49:06 | where's ALTER TABLE table DROP [ COLUMN ] column??? |