資料・データ laclassroom indexsetup01

DROP TABLE t1;

CREATE TABLE t1(id1 INTEGER, id2 INTEGER, data TEXT); CREATE OR REPLACE FUNCTION indexsetup01() RETURNS VOID AS ' BEGIN

FOR i IN 1 .. 500 LOOP FOR j IN 1 .. 500 LOOP

INSERT INTO t1 VALUES(i, j, ''data_'' || i || ''_'' || j); END LOOP;

END LOOP; END;

' LANGUAGE PLPGSQL; SELECT indexsetup01(); SELECT count(*) FROM t1;