[GENERAL] Any way to use refcursors from python?

2010-12-29 Thread Andrew Sullivan
Hi all, For a little application I'm working on (written in Python), I have a number of potentially large result sets that I'd like to return from a PL/pgSQL function. My natural inclination would be to return a refcursor. It seems, however, that psycopg2 can't accept such references. Have I

Re: [GENERAL] Any way to use refcursors from python?

2010-12-29 Thread Daniele Varrazzo
On Wed, Dec 29, 2010 at 1:46 PM, Andrew Sullivan a...@crankycanuck.ca wrote: Hi all, For a little application I'm working on (written in Python), I have a number of potentially large result sets that I'd like to return from a PL/pgSQL function.  My natural inclination would be to return a

Re: [GENERAL] Any way to use refcursors from python?

2010-12-29 Thread Andrew Sullivan
On Wed, Dec 29, 2010 at 03:05:26PM +0100, Daniele Varrazzo wrote: There is support for named cursors instead: if you use: Yeah, this I got. But. . . just client side manipulations. So there may be some small sql you may execute (may it be select * from my_function()? -- don't know the