Em segunda-feira, 4 de agosto de 2014, testman1316 <danilo(dot)ramirez(at)hmhco(dot)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