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 wrote: > I have fixed the problem populating a list and returning it. > &g

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 wrote: > > > ----- "Nun

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 wrote: > On Sunday 16 August 2009 5:13:51 pm Nuno Mota wrote: >

[GENERAL] plpython return setof and yield

2009-08-16 Thread Nuno Mota
is execute some SQL then process it and return it back. I 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