Function with now() | time 'now' | etc...

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
[edipoelder(at)ig(dot)com(dot)br]

_________________________________________________________
Oi! Voc quer um iG-mail gratuito?
Ento clique aqui: http://www.ig.com.br/paginas/assineigmail.html