Re: [HACKERS] Problem with copying abstimes - Mailing list pgsql-hackers

From Ronald Baljeu
Subject Re: [HACKERS] Problem with copying abstimes
Date
Msg-id 35f24c9423b2f223ec34559cdbf46025
Whole thread Raw
In response to [HACKERS] Problem with copying abstimes  (Ronald Baljeu <rjb@xs4all.nl>)
List pgsql-hackers
Thomas G. Lockhart wrote:
> Ronald Baljeu wrote:
> > I took a quick look at the source (src/backend/utils/adt/nabstime.c). It
> > really boggles my mind.
>
> Well, thank you!

You're welcome!

> Though the really fun code is in dt.c...

Aha... So here it is! I was looking at the wrong place (bummer :) )
I was wondering where you would put your lookup table for timezone strings.
Silly me. I should have done grep -i 'MET'...
                                   ^
> btw, you probably already know that there _are_ several timezone strings
> in Postgres to handle Australia; AEST, AESST, ACST, ACSST, AWST, AWSST,
> CADT, CAST, EAST, LIGT, SADT, SAST, WADT, WAST, WDT, WST are all in
> there. In fact, seems that Australia is overrepresented with time zone
> support :)

Well, if this planet would start turning at random directions
like a bowling ball, Australia shouldn't have to worry about having
too few timezones in directions other than East-West :-)

Cheers,
Ronald

------------------------------

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] 6.1 jumbo patch?
Next
From: Frank Dana
Date:
Subject: Re: [HACKERS] Problem with copying abstimes