Re: Additional current timestamp values

Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > Rather than applying the above patch, I have implemented this TODO
> > with the attached patch:
> >
> >     * Add transaction_timestamp(), statement_timestamp(),
> > clock_timestamp() functionality
>
> The most common complaint that I recall is that current_timestamp
> returns the transaction timestamp rather than the statement timestamp,
> which is what many expect.  How does your patch address that?

No, we believe the standard requires it.

> Do we really need clock_timestamp?

Yes, because timeofday() returns a unix text string.  Some people do
want a wallclock current timestamp.

--
  Bruce Momjian   http://candle.pha.pa.us
  SRA OSS, Inc.   http://www.sraoss.com

  + If your life is a hard drive, Christ can be your backup. +