Re: invalid input syntax for type timestamp.

Поиск
Список
Период
Сортировка
От Joachim Wieland
Тема Re: invalid input syntax for type timestamp.
Дата
Msg-id 20061216105732.GA2250@mcknight.de
обсуждение исходный текст
Ответ на Re: invalid input syntax for type timestamp.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: invalid input syntax for type timestamp.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: tomas@tuxteam.de
Дата:
Сообщение: Re: Operator class group proposal
Следующее
От: ohp@pyrenet.fr
Дата:
Сообщение: Re: unixware and --with-ldap