Em segunda-feira, 4 de agosto de 2014, testman1316 <
danilo.ramirez@hmhco.com> escreveu:
SET SERVEROUTPUT ON
SET TIMING ON
DECLARE
n NUMBER := 0;
BEGIN
FOR f IN 1..10000000
LOOP
n := SQRT (f);
END LOOP;
In addition to the other suggestions that have been posted (using a procedural language more suitable to mathematical ops, etc) I noticed that you are using a RAISE in the PostgreSQL version that you are not in Oracle.
I am curious as to what the difference is if you use the RAISE in both or neither cases.
Roberto