Ezequias R. da Rocha escreveu:
Hi list,
I would like to test the power of processing of postgresql (and my
server) by insert a large ammount of data on a table I have.
I would like to know how to implement a For... loop . With it I think
I could check the real power of my server.
Ezequias
I tryed a way but it is not working. Please see it:
LOOP;
-- some computations
insert into carga (desc) values ('My Text');
IF count > 1000000 THEN
EXIT; -- exit loop
END IF;
END LOOP;
The postgresql reports the following error:
/
ERROR: syntax error at or near "LOOP"
SQL state: 42601
Character: 1/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
