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. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend