Re: BUG #5354: Type timestamptz doesn't allow to store time zone

Thank you for the response. I see your point. When I insert into field timezonetz it does convert into correct timezone and inserts the converted value. At the same time timestamp field just drops the timezone and inserts the value.

However, I think that confusion comes when timetz works differently. Are there any plans to make them work the same either one way or another.

Thanks,
Vitali

----- Original Message -----
From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: robertmhaas(at)gmail(dot)com, vitali(at)lumensoftware(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Sent: Tuesday, March 2, 2010 7:35:32 AM
Subject: Re: [BUGS] BUG #5354: Type timestamptz doesn't allow to store time zone

Robert Haas wrote:
> Vitali wrote:

>> 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.

We should probably add this to the FAQ -- the OP was expecting the
behavior specified by the standard, in which TIMESTAMP WITH TIME ZONE
includes a time zone.

-Kevin