Re: BUG #6605: wrong type cast from timestamp to timestamptz - Mailing list pgsql-bugs

> Tom Lane  wrote:
> eshkinkot@gmail.com writes:
>> set timezone to 'W-SU'; select '2011-03-27 23:00:00'::timestamptz;
>> SET
>> timestamptz
>> ------------------------
>> 2011-03-28 02:59:54+04
>
> Bizarre. On my Fedora 16 box, I see a different misbehavior:
>
> regression=# set timezone to 'Europe/Moscow'; select '2011-03-27
> 23:00:00'::timestamptz;
> SET
> timestamptz
> ------------------------
> 2011-03-28 00:29:40+04
> (1 row)

Ubuntu 10.04 LTS
Linux kevin-desktop 2.6.32-40-generic-pae #87-Ubuntu SMP
  Mon Mar 5 21:44:34 UTC 2012 i686 GNU/Linux

PostgreSQL 9.2devel on i686-pc-linux-gnu,
  compiled by gcc (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 32-bit

test=# set timezone to 'Europe/Moscow'; select  '2011-03-27
23:00:00'::timestamptz;
SET
      timestamptz
------------------------
 2011-03-28 00:29:40+04
(1 row)

-Kevin