drop table t1; create table t1(id1 integer, id2 integer, data text); create or replace function setup151() returns void as $$ declare s1 text; s2 text; s3 text; begin for i in 1..1000 loop for j in 1..100 loop if (i + j) % 2 = 0 then s1 := 'DATA'; else s1 := 'data'; end if; s2 := to_char(i, '_FM0000'); s3 := to_char(j, '_FM000'); insert into t1 values(i, j, s1 || s2 || s3); end loop; end loop; return; end; $$ language plpgsql; select setup151();