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