Anoop G wrote:
Hi ,
Iam new to plpython,how can I return a recordset from a plpython
function?
Is there is any way give me an example;
plpgsql function
--------------------------------
CREATE OR REPLACE FUNCTION function_to_get_all_countries() RETURNS SETOF
RECORD AS $BODY$
DECLARE
r RECORD;
BEGIN
FOR r IN SELECT pk_bint_country_id,vchr_country FROM tbl_country LOOP
RETURN NEXT r;
END LOOP;
RETURN;
END
$BODY$ LANGUAGE 'plpgsql';
How i can get the same result using plpythonu and how I can call the
function (is there any user defined type required like in plpgsql)?
Thanks in advance
Anoop
Forgot to mention that postgres home page has some info about plpython.
http://www.postgresql.org/docs/8.3/static/plpython-funcs.html
Cya.
Gerardo
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql