ecpg: using cursor returned from a stored function

Lists: pgsql-interfaces
From: "Gaetano Sferra" <gaesferr(at)libero(dot)it>
To: "pgsql-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: ecpg: using cursor returned from a stored function
Date: 2004-11-09 11:39:57
Message-ID: I6WTQLD2D80B1981607DF63716A0A9E8AEB1E@libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-interfaces

Hello to all,
I he some stored functions that returns a refcursor and I need to use this
cursor In my ECPG programs.
I've serached for documentation but I don't found anything about it so: How I
can do it?
Looking in the include files of PG I don't found a cursor data type so I don't
have any ideas on how proceed.

Thank you,
Gaetano Sferra

____________________________________________________________
Libero ADSL: navighi gratis a 1.2 Mega, senza canone e costi di attivazione.
Abbonati subito su http://www.libero.it


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Gaetano Sferra" <gaesferr(at)libero(dot)it>
Cc: "pgsql-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: ecpg: using cursor returned from a stored function
Date: 2004-11-09 16:35:55
Message-ID: 200411091735.55793.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg토토 꽁 머니SQL :

Am Dienstag, 9. November 2004 12:39 schrieb Gaetano Sferra:
> I he some stored functions that returns a refcursor and I need to use this
> cursor In my ECPG programs.

Cursors in ECPG are managed differently, so I strongly suspect that your idea
won't work.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/