Re: Exclusion constraints with time expressions

hari.fuchs@gmail.com

> No: the result of e.g.
>
>  SELECT TIMESTAMPTZ '2012-10-28 01:30:00' + INTERVAL '24 hours';
>
> depends on the client's timezone and its DST rules.

Can you give an example of where adding an interval based on *hours*
to TIMESTAMP WITH TIME ZONE would give a different value based on
client's time zone and DST rules? If there is such a case, we have a
bug, IMO.

Now, if you wanted to argue that *this* query might depend on time
zone information, I'd be more willing to believe it, and maybe the
problem is that we use the same function for both:

SELECT TIMESTAMPTZ '2012-10-28 01:30:00' + INTERVAL '1 day';

-Kevin