On Mon, Jul 12, 2010 at 4:15 AM, A. Kretschmer
> In response to Atul(dot)Goel(at)globaldatapoint(dot)com :
>> 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();
> Use timeofday() instead, now() returns the transaction starting time.
Is this part of the SQL standard?
In response to
pgsql-performance by date
|Next:||From: Thom Brown||Date: 2010-07-12 13:23:55|
|Subject: Re: now() gives same time within the session|
|Previous:||From: Kevin Grittner||Date: 2010-07-12 12:41:36|
|Subject: Re: Pooling in Core WAS: Need help in performance tuning.|