Re: Difference when using ZIC vs. Timezone Abbr - Bug?

Dave Witt <dwitt@movenetworks.com> writes:
> These two queries produce different output, using version 8.3.3:
> SELECT '2008-01-01 00:00:00+00'::timestamptz AT TIME ZONE 'MDT';
> SELECT '2008-01-01 00:00:00+00'::timestamptz AT TIME ZONE 'America/Boise';

Why are you surprised?  Boise would've been on MST not MDT on that date.
        regards, tom lane