Shoaib Mir wrote: > You can use a SETOF function as: > > CREATE OR REPLACE FUNCTION get_test_data (numeric) > RETURNS SETOF RECORD AS > $$ > DECLARE > temp_rec RECORD; > BEGIN > FOR temp_rec IN (SELECT ename FROM emp WHERE sal > $1) > LOOP > RETURN NEXT temp_rec; > END LOOP; > RETURN; > END; > $$ LANGUAGE plpgsql; > This doesn't work. ;( I get ERROR: a column definition list is required for functions returning "record" SQL state: 42601 when running this function
