How to return a record and sets of record in plpython

Question posted by: RL (Guest) on November 23rd, 2005 02:04 AM

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

Not the answer you were looking for? Post your question . . .
190,472 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).