Hi all,
I´m developing some procedures in my db and i want know how much time my
procedures take to execute. So, i write my first procedure (to test) as
follows:
CREATE FUNCTION TEST(INTEGER) RETURNS INTEGER AS '
DECLARE
SEQ RECORD;
BEGIN
SELECT NEXTVAL(''TIMES_ID_SEQ'') AS ID INTO SEQ;
INSERT INTO TIMES (ID, START) VALUES (SEQ.ID, NOW());
FOR I IN 1..$1 LOOP ^^^^^
INSERT INTO TEST(ANUMBER) VALUES (RANDOM()*$1);
END LOOP;
UPDATE TIMES SET END = NOW() WHERE ID = SEQ.ID;
RETURN SEQ.ID; ^^^^^
END;'
LANGUAGE 'PLPGSQL';
and executed using "SELECT TEST(10000);". When it finish, i do a "SELECT
* FROM TIMES" and got:
test=> SELECT * FROM TIMES;
start | end | id
----------+----------+----
10:27:55 | 10:27:55 | 12
10:27:55 | 10:27:55 | 13
10:30:29 | 10:30:29 | 14
10:31:29 | 10:31:29 | 15
(4 rows)
In id = 12 and id = 13, i runned two times. Then I changed the function
and run, at id = 14. Change again at id = 15.
Where is underlined (^^^^), i tried to put, 'now', timestamp 'now', etc,
and always get the same time. What i'm doing wrong?
obs.: -> TABLE TEST (ID SERIAL, ANUMBER INTEGER)
-> TABLE TIMES (ID SERIAL, START TIME, END TIME);
-> PostgreSQL 7.0.2 under Conectiva Linux
Thanks,
Edipo Elder
[[EMAIL PROTECTED]]
_________________________________________________________
Oi! Você quer um iG-mail gratuito?
Então clique aqui: http://www.ig.com.br/paginas/assineigmail.html
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
