[SQL] how to returns set of records in PL/python

[Anoop G]

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