Code L

-- Function: get_record_row1(integer)

-- DROP FUNCTION get_record_row1(integer);

CREATE OR REPLACE FUNCTION get_record_row1(i integer)
RETURNS emp AS
$BODY$
DECLARE
rec RECORD;
BEGIN
EXECUTE 'SELECT * from emp where empno =' || i INTO rec;
RETURN rec;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION get_record_row1(integer)
OWNER TO postgres;