Re: [GENERAL] CURRENT_TIMESTAMP - Mailing list pgsql-sql

From Josh Berkus
Subject Re: [GENERAL] CURRENT_TIMESTAMP
Date
Msg-id 200209291243.45747.josh@agliodbs.com
Whole thread Raw
In response to Re: [GENERAL] CURRENT_TIMESTAMP  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] CURRENT_TIMESTAMP  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: [GENERAL] CURRENT_TIMESTAMP  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom,

> I'd be happier with the whole thing if anyone had exhibited a convincing
> use-case for statement timestamp.  So far I've not seen any actual
> examples of situations that are not better served by either transaction
> timestamp or true current time.  And the spec is perfectly clear that
> CURRENT_TIMESTAMP does not mean true current time...

Are we still planning on putting the three different versions of now() on the
TODO?  I.e.,
now('transaction'),
now('statement'), and
now('immediate')
With now() = now('transaction')?

I still think it's a good idea, provided that we have some easy means to
determine now('statement').

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP
Next
From: Josh Berkus
Date:
Subject: Proposal for Clean-up of Conversion Functions