Re: [GENERAL] cursors from pl/pgsql

2010-04-07 Thread Marc Menem
hi guys, i solved this particular issue using the fetch syntax, so thanks for the tip. I agree with merlin that temp tables are a headache, also because i can't run the same function again before processing the output; I am not familiar with arrays, but it seems like a good solution for my proble

Re: [GENERAL] cursors from pl/pgsql

2010-04-07 Thread Merlin Moncure
On Tue, Apr 6, 2010 at 9:58 PM, Marc Menem wrote: > Hi all, > > I'm trying to use a cursor returned by a function from another function. But > I can't seem to get it working correctly. The error message is: >   ERROR:  cursor FOR loop must use a bound cursor variable > I am not sure how to bind it

Re: [GENERAL] cursors from pl/pgsql

2010-04-06 Thread Pavel Stehule
Hello 2010/4/7 Marc Menem : > Hi all, > > I'm trying to use a cursor returned by a function from another function. But > I can't seem to get it working correctly. The error message is: >   ERROR:  cursor FOR loop must use a bound cursor variable > I am not sure how to bind it; you can't do it now