Re: Revisiting extract(epoch from timestamp)

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