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. +