Postgres Pro
Downloads
Home   >   mailing lists

Re: now() in loop statement - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: now() in loop statement
Date
Msg-id 3F783022.8030207@klaster.net
Whole thread Raw
In response to now() in loop statement  (Kerv <keresztes_m@yahoo.com>)
List pgsql-sql
Tree view 
> Hello,
> 
> What is wrong with this function because the mytime variable contain the 
> same value in each iteration:

Just like it should be.
now() gives you always the same value inside single transaction. If you 
need time for performance tests - use "timeofday".

Regards,
Tomasz Myrta

pgsql-sql by date:

Previous
From: Kerv
Date:
Subject: now() in loop statement
Next
From: Christoph Haller
Date:
Subject: Re: now() in loop statement