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

Vitali Malinouski wrote:
> 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.

I think we are following the specification on that one so I don't see
how we can change it.

---------------------------------------------------------------------------

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

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do