Re: plpython return setof and yield

[Nuno Mota <nmota@xxxxxxxxxx>]

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 <nmota@xxxxxxxxxx> wrote:

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 <aklaver@xxxxxxxxxxx> wrote:

----- "Nuno Mota" <nmota@xxxxxxxxxx> wrote:

> 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
>
>

From here:
http://www.postgresql.org/docs/8.3/interactive/plpython-funcs.html

"The result is returned from the Python code in the usual way, with return or yield (in case of a result-set statement). "

Adrian Klaver
aklaver@xxxxxxxxxxx

--
Nuno Mota <nmota@xxxxxxxxxx>

Management Solutions for POS
Tlf:  351 225322000
Mob:  351 936272176
Fax:  351 226177662
http://www.net-bo.com

-- 
Nuno Mota <nmota@xxxxxxxxxx>

Management Solutions for POS
Tlf:  351 225322000
Mob:  351 936272176
Fax:  351 226177662
http://www.net-bo.com