On 2005-10-26, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> John R Pierce <pierce@hogranch.com> writes:
>> the whole DST thing falls apart when you deal with places that don't
>> respect it... arizona (except the navajo nation), for instance....
>
>> it would be impossible to calculate the 'correct' answer without knowing
>> the exact location...
>
> No, rather say "without knowing the correct timezone". All of this is
> about doing the calculations properly according to the rules of the
> current TimeZone setting.
Um, what? Under what conditions is it permissable for simple arithmetic on
(only) timestamptz values (which may have originated in different timezones
neither of which is the current one) to be dependent on the current timezone
setting?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services