"chris wood" <chrisj.wood@sympatico.ca> writes:
> postgresbugs=# select '2008-01-09 07:00:00-00'::timestamptz at time zone
> 'right/Pacific/Wake' ;
> timezone
> ---------------------
> 2008-01-09 18:59:37 <<<<<<<<<???????
> (1 row)
The "right" timezones take leap seconds into account, so this isn't
surprising.
(We don't actually support leap seconds, so I wonder whether we
shouldn't filter those zones out of the view. They're not there at all
if you set up Postgres to use an internal tz database, but I suppose we
have to accept that they're likely to be present in a system-supplied tz
database.)
regards, tom lane