Ejemplo 6: SRF en SQL

CREATE FUNCTION getfoo(int)
    RETURNS setof foo AS '
        SELECT * FROM foo
        WHERE fooid = $1;'
    LANGUAGE SQL;

SELECT * FROM getfoo(1);