Re: invalid input syntax for type timestamp.

On Sat, Dec 16, 2006 at 10:26:52AM -0500, Tom Lane wrote:
> Joachim Wieland <joe(at)mcknight(dot)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