Re: Timezone database changes

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Trevor Talbot" <quension(at)gmail(dot)com>,<Magne(dot)Mahre(at)Sun(dot)COM>, "Kevin Grittner" <Kgrittn(dot)CCAP(dot)Courts(at)wicourts(dot)gov>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Aidan Van Dyk" <aidan(at)highrise(dot)ca>, <pgsql-hackers(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Timezone database changes
Date: 2007-10-10 20:32:47
Message-ID: 470CF09D.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>> On Wed, Oct 10, 2007 at 2:51 PM, in message
<470CE6E2(dot)EE98(dot)0025(dot)0(at)wicourts(dot)gov>, "Kevin Grittner"
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>>>> On Wed, Oct 10, 2007 at 12:23 PM, in message
> <470D0A90(dot)9000401(at)sun(dot)com>, Magne
> Mæhre <Magne(dot)Mahre(at)Sun(dot)COM> wrote:
>> An interesting observation is that,
>> as far as I can tell, the original time zone is only applied when
> casting
>> the element to a string. Apart from that, it's not used.
>
> It's been a while since I looked at it, but my recollection is that
> much of the standard date/time math which people assert can't handle
> practical use cases do work if the timestamps and times WITH TIME
> ZONE have a time zone in the offset-from-UTC format. I have yet to
> see anyone provide an example where this isn't true; if anyone has
> such an example, it would be instructive to see it.

Withdrawn. Tom posted an example today which crossed mine in the
mail.
I see his point.

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-10-10 21:10:17 Re: Skytools committed without hackers discussion/review
Previous Message andy 2007-10-10 20:31:35 Re: full text search in 8.3