"David E. Wheeler" <david(at)kineticode(dot)com> wrote:
> I like it, but what do you do when a TZ has been renamed or has
> ceased to exist. Or, worse, existed last week, so last week's
> dates might still use it, but next week's must not?
I think the key thing is that the timestamp portion of it would be
identical to our current TIMESTAMP WITH TIME ZONE -- always store it
in the value UTC zone. That way comparisons and math between
timestamps could remain sane. The stored time zone portion would be
what it would be the display format, if usable. In an extreme
situation like you describe above, I guess you could fall back on
what we do now for display of a timestamptz value.
Personally, I think it would be good to move a bit closer to the
standard by including a time zone in a TIMESTAMP WITH TIME ZONE
value. The biggest problem I can see is how to try to do this in a
standard conforming fashion without breaking existing code. It
would seem more than a little odd to support the standard semantics
with nonstandard syntax and vice versa.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2011-05-27 21:35:41|
|Subject: Re: storing TZ along timestamps |
|Previous:||From: Peter Eisentraut||Date: 2011-05-27 21:24:14|
|Subject: Re: How can I check the treatment of bug fixes?|