Re: Timezone database changes - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Timezone database changes
Date
Msg-id 470CE6E2.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Timezone database changes  (Magne Mæhre <Magne.Mahre@Sun.COM>)
Responses Re: Timezone database changes
Re: Timezone database changes
List pgsql-hackers
>>> On Wed, Oct 10, 2007 at 12:23 PM, in message
<470D0A90.9000401@sun.com>, Magne
Mæhre <Magne.Mahre@Sun.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.
-Kevin



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Skytools committed without hackers discussion/review
Next
From: "Marko Kreen"
Date:
Subject: Re: Skytools committed without hackers discussion/review