Re: time math - Bug or expected behavior?

Adam Rich <adam(dot)r(at)sbcglobal(dot)net> writes:
> I traced a bug in our application down to this basic operation:
> set timezone to 'US/Eastern';

> select '11/02/2008'::timestamptz, '12:10'::time,
> '11/02/2008'::timestamptz + '12:10'::time;

> I have a date and a time stored separately and I want to combine them,
> and use them in some timezone-aware calculations. When I add the time
> 12:10 to the date 11/2/08, I expect the timestamp "11/2/08 12:10" but
> instead, I get "11/2/08 11:10".

I don't see why that surprises you in the least.
'11/02/2008'::timestamptz means 11/02/2008 00:00 local time, and (given
US DST rules) 11/2/08 11:10 is what the time will be 12 hours and 10
minutes later.

If you want non-DST-aware timekeeping, use timestamp without time zone.

> Still, I would have expected the above behavior
> when adding an interval to a timestamp, but not a time.

How could a time work differently from an interval in this context?

regards, tom lane