Hi all, I wrote the folling function: DROP FUNCTION PROC_TESTE(INTEGER); CREATE FUNCTION PROC_TESTE(INTEGER) RETURNS INTEGER AS ' DECLARE SEQ RECORD; BEGIN SELECT NEXTVAL(''TEMPOS_ID_SEQ'') AS ID INTO SEQ; INSERT INTO TEMPOS (ID, INICIO) VALUES (SEQ.ID, NOW()); FOR I IN 1..$1 LOOP INSERT INTO TESTE(VALOR) VALUES (RANDOM()*$1); END LOOP; UPDATE TEMPOS SET FIM = NOW() WHERE ID = SEQ.ID; RETURN SEQ.ID; END;' LANGUAGE 'PLPGSQL'; And all times I run it ("select proc_teste(10000);"), i got the folling behavour: teste=> SELECT * FROM TEMPOS; inicio | fim | id ----------+----------+---- 15:12:17 | 15:12:17 | 23 15:12:18 | 15:12:18 | 24 (...) It doesn't getting different times on each execution. I also tried put "timestamp 'now'" insted "now()". What am I doing wrong? Thank you, 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