Re: gettime() - a timeofday() alternative

Brendan Jurd wrote:
> Hi all,
> 
> I propose to add an internal function gettime() that transparently
> returns the current system time, as a timestamptz with maximum
> precision.
> 
> Calling gettime() would be a more elegant approach than calling
> timeofday() and converting it to a timestamp, and avoids some of the
> potential problems in that conversion (such as "Sat" being
> misinterpreted as an Australian timezone).
> 
> I'm open to alternate suggestions for the name of the function.
> 
> If there are no objections, I'll start cooking up a patch right away.

We already have a TODO for this:* Add transaction_timestamp(), statement_timestamp(), clock_timestamp()  functionality
CurrentCURRENT_TIMESTAMP returns the start time of the current  transaction, and gettimeofday() returns the wallclock
time.This will  make time reporting more consistent and will allow reporting of  the statement start time.
 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073