Re: Revisiting extract(epoch from timestamp) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Revisiting extract(epoch from timestamp)
Date
Msg-id 11131.1333996701@sss.pgh.pa.us
Whole thread Raw
In response to Re: Revisiting extract(epoch from timestamp)  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Revisiting extract(epoch from timestamp)  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
>> Robert Haas <robertmhaas@gmail.com> writes:
>>> If somebody needs it I'd probably be in favor of doing it.  I'm not
>>> sure I'd do it on spec.

> It would be useful to have a simple function to use with timestamp in
> constraint exclusion without having to use contorted expressions ...
> An immutable extract_epoch(timestamptz) would fit the bill.

What exactly would you do with it there that you couldn't do more easily
and clearly with plain timestamp comparisons?  I'm willing to be
convinced, but I want to see a case where it really is the best way.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Regarding column reordering project for GSoc 2012
Next
From: Tom Lane
Date:
Subject: Re: bug in fast-path locking