Timestamp + Interval time zone issues

[Chuck Swiger]

Hi--

On Jul 28, 2010, at 11:28 AM, Mike Ginsburg wrote:
> When I then try to add an interval to a statically entered time stamp, it gets all strange:
> SELECT '01/03/2011 16:00:00-04'::timestamp with time zone + '-1 hour'::interval;
>       ?column?        -------------------------
> 01/03/2011 14:00:00 EST
> 
> Any idea why the adding of the interval is converting the result into EST instead of EDT?

I'd image this is because Jan 3 is in EST:

% date -j '01031600'
Sun Jan  3 16:00:00 EST 2010

Regards,
-- 
-Chuck