now() gives same time within the session

Hi,

I need to log the start and end time of the procedures in a table. But the start and end time are same. This is how I recreated the issue.

create table test_time (time timestamp);

delete from  test_time;

insert into test_time select now();

SELECT pg_sleep(10);

insert into test_time select now();

SELECT pg_sleep(10);

insert into test_time select now();

SELECT pg_sleep(10);

insert into test_time select now();

SELECT pg_sleep(10);

select * from test_time;

"2010-07-12 12:43:40.509746"

"2010-07-12 12:43:40.509746"

"2010-07-12 12:43:40.509746"

"2010-07-12 12:43:40.509746"

Atul Goel

SENIOR DEVELOPER

Global DataPoint

Middlesex House, 34-42 Cleveland Street

London W1T 4LB, UK

T: +44 (0)20 7079 4827

M: +44 (0)7846765098

www.globaldatapoint.com