Re: invalid input syntax for type timestamp.

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