Re: now() in loop statement

From: "Dan Langille" <dan(at)langille(dot)org>
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:17:28
Message-ID: 3F77F8A8.10229.33B6CEFF@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 29 Sep 2003 at 15:58, Kerv wrote:

> What is wrong with this function because the mytime variable contain the
> same value in each iteration:

>From http://www.postgresql.org/docs/7.3/static/functions-
datetime.html:

It is important to realize that CURRENT_TIMESTAMP and related
functions return the start time of the current transaction; their
values do not change during the transaction. timeofday() returns the
wall clock time and does advance during transactions.
--
Dan Langille : http://www.langille.org/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dan Langille 2003-09-29 14:03:19 Re:
Previous Message Tomasz Myrta 2003-09-29 13:14:10 Re: now() in loop statement