Re: BUG #1993: Adding/subtracting negative time intervals - Mailing list pgsql-bugs

From Andrew - Supernews
Subject Re: BUG #1993: Adding/subtracting negative time intervals
Date
Msg-id slrndluagf.g61.andrew+nonews@trinity.supernews.net
Whole thread Raw
In response to Re: BUG #1993: Adding/subtracting negative time intervals  (Klint Gore <kg@kgb.une.edu.au>)
Responses Re: BUG #1993: Adding/subtracting negative time intervals
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Andrew - Supernews
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals
Next
From: Andrew - Supernews
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals