Re: Bug or feature? Timestamp parsing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bug or feature? Timestamp parsing
Date: 2010-06-10 02:37:03
Message-ID: 5617.1276137423@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> It appears that the ts parser will ignore any punctuation surrounding
> the special value calls.

The datetime parser ignores "extraneous" punctuation all over the place,
not only with regards to special values. I'm hesitant to monkey with
that, because there are so many weird date formats out there.

> On the other hand, it appears that our timestamps have had this bug
> since at least 8.0, so it clearly isn't a widespread problem for most
> users.

It's had that behavior since Tom Lockhart was messing with it, maybe
even before that.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-06-10 02:56:56 Re: InvalidXLogRecPtr in docs
Previous Message Mark Kirkwood 2010-06-10 02:36:13 Re: failover vs. read only queries