hari.fu...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
