Re: now() in loop statement

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Kerv <keresztes_m(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: now() in loop statement
Date: 2003-09-29 13:14:10
Message-ID: 3F783022.8030207@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dan Langille 2003-09-29 13:17:28 Re: now() in loop statement
Previous Message Kerv 2003-09-29 12:58:30 now() in loop statement