On Mon, Mar 1, 2010 at 10:52 AM, Vitali <[email protected]> wrote: > > The following bug has been logged online: > > Bug reference: 5354 > Logged by: Vitali > Email address: [email protected] > PostgreSQL version: 8.1.x 8.2.x > Operating system: Windows, Linux > Description: Type timestamptz doesn't allow to store time zone > Details: > > I have a table: > > CREATE TABLE test ( > set_dt timestamptz, > set_tm timetz > ) WITH OIDS; > > I do insert into this table: > > INSERT INTO test(set_dt, set_tm) > VALUES('2010-01-01 10:00+02', '10:00+02') > > When I select from the table, the timetz has the correct time zone, the > timestamptz has -6 as a time zone, which is my server default.
I'm not sure what you think the bug is, but timestamptz definitely doesn't store the time zone in which the value is input. What it does is makes input and output relative to the then-current time zones rather than fixed wall-clock times. ...Robert -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
