Re: [GENERAL] CURRENT_TIMESTAMP

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: John Hasler <john@dhh.gt.org>
Cc: pgsql-sql@postgresql.org
Date: 2002-09-24T03:17:32Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql
John Hasler wrote:
> Bruce Momjian writes:
> > My point is that our current behavior may not be the most intuitive, and
> > that most people may prefer a change.
> 
> I would prefer a change.

Yes, I guess that is my point, that we want to make transaction _and_
statement timestamp values available, but most people are going to use
current_timestamp, and most people are going to assume it is statement
time, not transaction time.

Can I add TODO items for this:

	o Make CURRENT_TIMESTAMP/now() return statement start time
	o Add TRANSACTION_TIMESTAMP to return transaction 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, Pennsylvania 19073