CREATE FUNCTION updateTchrNm() RETURNS void AS $body$ DECLARE rownum integer := 1; BEGIN while rownum <= 1000 LOOP update t_tchr set tchr_nm = '田中愛子' || rownum,tchr_knm = 'タナカアイコ' || rownum,tchr_anm = 'tanaka' || rownum where tchr_cd = 'TCHR' || (1000000 + rownum); rownum := rownum + 1; END LOOP; return; END; $body$ LANGUAGE 'plpg<a href="/tag/sql/" target="_blank" class="keywords">sql</a>'; select updateTchrNm();