Re: invalid input syntax for type timestamp. - Mailing list pgsql-hackers

From Joachim Wieland
Subject Re: invalid input syntax for type timestamp.
Date
Msg-id 20061216163851.GA4084@mcknight.de
Whole thread Raw
In response to Re: invalid input syntax for type timestamp.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: invalid input syntax for type timestamp.
List pgsql-hackers
On Sat, Dec 16, 2006 at 10:26:52AM -0500, Tom Lane wrote:
> Joachim Wieland <joe@mcknight.de> writes:
> > True... Actually I wonder how I have to read the zic files in this case.
> > It says:

> > Rule    Japan    1948    only    -    May    Sun>=1    2:00    1:00    D
> > Rule    Japan    1948    1951    -    Sep    Sat>=8    2:00    0    S
> > Rule    Japan    1949    only    -    Apr    Sun>=1    2:00    1:00    D
> > Rule    Japan    1950    1951    -    May    Sun>=1    2:00    1:00    D

> > Zone    Asia/Tokyo    9:18:59    -    LMT    1887 Dec 31 15:00u
> >             9:00    -    JST    1896
> >             9:00    -    CJT    1938
> >             9:00    Japan    J%sT

> It looks to me like this says that the only time Japan ever observed DST
> was during the American occupation immediately after WWII.  I can well
> imagine that they'll never adopt it on their own given that history.

Yes, I completely agree that JDT should not be included. I just wanted to
understand how those lines show that JST is still in active use. As far as I
understand it, it says that JST was observed from 1948 to 1951 (the second
rule) and now there is a time zone "J%sT" (because there is no "until"-date
in the last line) but there is no rule that tells us what to replace "%s"
with...


Joachim




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: pg_am.amstrategies should be 0 when not meaningful?
Next
From: "Andrew Dunstan"
Date:
Subject: Re: Operator class group proposal