Re: plpython return setof and yield - Mailing list pgsql-general

From Nuno Mota
Subject Re: plpython return setof and yield
Date
Msg-id d79bf9b30908171158l1e8d61e2s6a7f6e2d1b8fdba7@mail.gmail.com
Whole thread Raw
In response to Re: plpython return setof and yield  (Nuno Mota <nmota@net-bo.com>)
List pgsql-general
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@net-bo.com> 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@comcast.net> wrote:


----- "Nuno Mota" <nmota@net-bo.com> 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@comcast.net



--
Nuno Mota <nmota@net-bo.com>

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



--
Nuno Mota <nmota@net-bo.com>

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

pgsql-general by date:

Previous
From: Nuno Mota
Date:
Subject: Re: plpython return setof and yield
Next
From: Tom Lane
Date:
Subject: Re: ERROR: attempted to delete invisible tuple