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 20061216105732.GA2250@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 Fri, Dec 15, 2006 at 11:37:56AM -0500, Tom Lane wrote:
> Joachim Wieland <joe@mcknight.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




pgsql-hackers by date:

Previous
From: tomas@tuxteam.de
Date:
Subject: Re: Operator class group proposal
Next
From: ohp@pyrenet.fr
Date:
Subject: Re: unixware and --with-ldap