Re: [HACKERS] Problem with copying abstimes

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

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