As far as I understand, though I hope someone will post that I'm wrong, plpython cannot return recordsets. In general, I use plpgsql when I want recordets and plpython when I want functionality. I have also called plpython functions from a plpgsql function when I wanted a single value result.
"RL" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
