Re: BUG #6605: wrong type cast from timestamp to timestamptz

Saturday, April 21, 2012, 7:49:55 PM you wrote:

> So: some platform-specific misbehavior here.  I have no time to poke at
> it more now, though.  Who else can reproduce this, on what platforms?

One machine works, the other not:

PostgreSQL 9.1.3 on i686-pc-linux-gnu, compiled by i686-pc-linux-gnu-gcc (Gentoo 4.5.3-r2 p1.0, pie-0.4.6) 4.5.3,
32-bit
Result: 2011-03-27 23:00:00+04

PostgreSQL 9.1.3 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (Gentoo 4.5.3-r2 p1.0, pie-0.4.6) 4.5.3,
64-bit
Result: 2011-03-28 00:29:40+04

--
Jochen Erwied     |   home: jochen@erwied.eu     +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work: joe@mbs-software.de  +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile: jochen.erwied@vodafone.de       +49-173-5404164