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
  SRA OSS, Inc.

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to