Re: [GENERAL] plpython return setof and yield

2009-08-17 Thread Nuno Mota
Thank you very much, Can i ask one more question ? How do I declare the correct result set to return, this in first example code, is it possible ? Thank you again, Nuno Mota On Mon, Aug 17, 2009 at 3:21 PM, Adrian Klaver akla...@comcast.net wrote: On Sunday 16 August 2009 5:13:51 pm Nuno

Re: [GENERAL] plpython return setof and yield

2009-08-17 Thread Nuno Mota
I have fixed the problem populating a list and returning it. Well I guess I have to learn a litte bit more of python to understand how to use yield when using multiple result sets. Thank you anyway On Mon, Aug 17, 2009 at 7:23 PM, Adrian Klaver akla...@comcast.net wrote: - Nuno Mota nm

Re: [GENERAL] plpython return setof and yield

2009-08-17 Thread Nuno Mota
Ok, now I think I understand since I already have a result set from the query I cannot use yield. The other example works because I am generating only one result set. On Mon, Aug 17, 2009 at 7:55 PM, Nuno Mota nm...@net-bo.com wrote: I have fixed the problem populating a list and returning

[GENERAL] plpython return setof and yield

2009-08-16 Thread Nuno Mota
also know I could just generate the rows and place them in a list and then return it, but I would like to know why the yield function does'nt work in this case. This was tried on with: PostgreSQL 8.3.7 and Python 2.5.1 Thanks, Nuno Mota