Re: current_timestamp after queries - Mailing list pgsql-general

From Tom Lane
Subject Re: current_timestamp after queries
Date
Msg-id 21610.1033399799@sss.pgh.pa.us
Whole thread Raw
In response to Re: current_timestamp after queries  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Need Oracle 9 tester. was Re: current_timestamp after queries
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Yes, timeofday() will work, but it can change during the statement, right?

For what he was doing, it seemed perfectly acceptable.

This comes back to the point I've been making during the pghackers
discussion: start-of-transaction time has clear uses, and
exact-current-time has clear uses, but it's not nearly as obvious
why you'd need start-of-statement time in preference to either of
the others.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] current_timestamp after queries
Next
From: Bruce Momjian
Date:
Subject: Need Oracle 9 tester. was Re: current_timestamp after queries