| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Michael Fuhr <mike(at)fuhr(dot)org>, Michael Glaesemann <grzm(at)myrealbox(dot)com>, Russell Smith <mr-russ(at)pws(dot)com(dot)au>, pgsql-bugs(at)postgresql(dot)org, Nicholas <hb(at)x256(dot)com> |
| Subject: | Re: BUG #1993: Adding/subtracting negative time intervals |
| Date: | 2005-10-26 04:44:50 |
| Message-ID: | 1881.1130301890@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
John R Pierce <pierce(at)hogranch(dot)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. It's irrelevant whether the calculations are
correct with respect to some other timezone rules; obviously they won't
be.
(A separate issue is whether we know the rules for any particular
timezone you might wish to use. I'm pretty sure the zic database covers
everything anyone could possibly care about, though ;-))
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Klint Gore | 2005-10-26 05:30:12 | Re: BUG #1993: Adding/subtracting negative time intervals |
| Previous Message | Tom Lane | 2005-10-26 04:38:06 | Re: BUG #1993: Adding/subtracting negative time intervals |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-10-26 04:55:06 | Re: add_missing_from breaks existing views |
| Previous Message | Christopher Kings-Lynne | 2005-10-26 04:44:10 | Re: Sequence dependencies |