Re: Bug #801: now() in transaction

On Fri, Oct 18, 2002 at 07:23:29 -0400,
pgsql-bugs(at)postgresql(dot)org wrote:
> Bhuvan A (bhuvansql(at)myrealbox(dot)com) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> now() in transaction
>
> Long Description
> I am using 7.2.1. now() returns same value ever, within transaction. If we use now() say 10 times in the same transaction, all 10 times we are getting the same value, irrespect of the interval. 7.2 too behaves similar.

This is how it is supposed to work. If you need the current time, rather
than transaction start time, use timeofday().

This is covered in the documentation.