Hi,

I am trying to implement a few functions in Plpython (in Postgresql 8.0.1).
However, I could find the solution in the documentation, so I would appreciate
your help. My question is how to return a record and sets of records in Plpython
if it's possible. For instance, if we have a table name EMP

CREATE TABLE EMP ( name text, salary integer, age integer )

according to the documentation, the following code will return a composite
type:

CREATE FUNCTION new_emp() RETURNS EMP AS '
SELECT text "None" AS name,
1000 AS salary,
25 AS age;
' LANGUAGE SQL;

and

"RETURN NEXT" in Pl/pgsql allows us to return multiple rows

How am I going to do the same thing in plpython?
Thanks,

Ruey-Lung Hsiao