Postgres Pro
Downloads
Home   >   mailing lists

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

From Nuno Mota
Subject Re: plpython return setof and yield
Date
Msg-id d79bf9b30908171155h75f4f3cbq9daa41960743cd0b@mail.gmail.com
Whole thread Raw
In response to Re: plpython return setof and yield  (Adrian Klaver <aklaver@comcast.net>)
Responses Re: plpython return setof and yield
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: psql command line editor
Next
From: Nuno Mota
Date:
Subject: Re: plpython return setof and yield