Re: [HACKERS] Not quite there on timezone names in timestamp input

2006-10-15 Thread Tom Lane
Martijn van Oosterhout writes: > On Sat, Oct 14, 2006 at 07:42:18PM -0400, Tom Lane wrote: >> On investigation, the problem seems to lie with ParseDateTime(), which >> is being quite finicky about what it will believe is a timezone name. > Last time I wrote some code with the zic database, I let

Re: [HACKERS] Not quite there on timezone names in timestamp input

2006-10-15 Thread Martijn van Oosterhout
On Sat, Oct 14, 2006 at 07:42:18PM -0400, Tom Lane wrote: > On investigation, the problem seems to lie with ParseDateTime(), which > is being quite finicky about what it will believe is a timezone name. > In particular it won't accept digits as part of the name. That can > probably be fixed but I'

[HACKERS] Not quite there on timezone names in timestamp input

2006-10-14 Thread Tom Lane
This doesn't work: regression=# select '2006-07-13 09:20:00 EST5EDT'::timestamptz; ERROR: invalid input syntax for type timestamp with time zone: "2006-07-13 09:20:00 EST5EDT" It never has worked in the past, of course, but I expected it to work in HEAD seeing that the zic database includes EST