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

From Ronald Baljeu
Subject Re: [HACKERS] Problem with copying abstimes
Date
Msg-id 36aeb3300bd2fe14ba04fae5576372fb
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: Robson Paniago de Miranda
Date:
Subject: [HACKERS] xid table corrupted.
Next
From: Ronald Baljeu
Date:
Subject: Re: [HACKERS] Problem with copying abstimes