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