Re: invalid input syntax for type timestamp.

On Fri, Dec 15, 2006 at 11:37:56AM -0500, Tom Lane wrote:
> Joachim Wieland <joe(at)mcknight(dot)de> writes:
> > Appended is a patch that adds JST and JDT into Asia.txt and the Default set.

> Um ... is there a JDT? Last I heard, Japan does not observe daylight
> time. I don't see a JDT in the old PG set of recognized zone names, and
> I'd think we'd have heard complaints long ago if it were needed.

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

The last column of the rules tell us what to put in for %s, but why is there
no

Rule Japan 19xx max .... S

rule? I.e. a rule saying that after some date we should always replace %s
by S? What am I missing here?

Joachim