Re: CURRENT_TIMESTAMP - Mailing list pgsql-hackers

From Michael Paesold
Subject Re: CURRENT_TIMESTAMP
Date
Msg-id 015701c26bc1$10f05040$4201a8c0@beeblebrox
Whole thread Raw
In response to Re: [SQL] [GENERAL] CURRENT_TIMESTAMP  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: CURRENT_TIMESTAMP  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> wrote:

> Yes, clearly, we will need to have all three time values available to
> users.  With three people now suggesting we don't change, I will just
> add to TODO:
>
> Add now("transaction|statement|clock") functionality
>
> Is that good?

CURRENT_TIMESTAMP etc. are converted to now()::TIMESTAMP, at least in 7.2,
right?
So when there are all three options available, it would be easy to change
the behaviour of CURRENT_DATE/TIME/TIMESTAMP, right?

SET .. or GUC would be options, no?

Best Regards,
Michael Paesold



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: numeric hierarchy again (was Re: floor function in 7.3b2)
Next
From: Manfred Koizar
Date:
Subject: Re: Return of INSTEAD rules