Function Yang Terdapat Looping - PostrgreSQL

Contoh penggunaan looping pada function

CREATE OR REPLACE FUNCTION "public"."fnc_tes"("user_id" int4)
RETURNS "pg_catalog"."text" AS $BODY$
DECLARE
titles TEXT DEFAULT '';
finalreport   record;
tesloop      "temporary".tmp_tes%ROWTYPE;

BEGIN
FOR tesloop IN
select * from "temporary".tmp_tes WHERE "row_number"<>4

loop
update "temporary".tmp_tes
set nilai = nilai+2
where row_number=tesloop.row_number;
end loop;

select nilai into finalreport from "temporary".tmp_tes;

RETURN finalreport;
END; $BODY$
LANGUAGE plpgsql VOLATILE
COST 100