Re: time stops within transaction - Mailing list pgsql-hackers

From Tom Lane
Subject Re: time stops within transaction
Date
Msg-id 3693.971840034@sss.pgh.pa.us
Whole thread Raw
In response to time stops within transaction  (Alex Pilosov <alex@pilosoft.com>)
Responses Re: time stops within transaction  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Alex Pilosov <alex@pilosoft.com> writes:
> I just ran into a strangest thing: within transaction, select now() will
> always return time when transaction started.

That is what now() is defined to return: transaction start time.
Perhaps the documentation needs improvement...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: time stops within transaction
Next
From: "John Huttley"
Date:
Subject: Re: time stops within transaction