| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, "Gevik Babakhani" <pgdev(at)xs4all(dot)nl> |
| Subject: | Re: TO_DATE behavior! |
| Date: | 2008-02-21 17:23:05 |
| Message-ID: | 12120.1203614585@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Gevik Babakhani wrote:
>> I would like to have your opinion about the following behavior of TO_DATE.
>> Is this correct or a hidden feature?
> There are quite a few complaints in the archive about to_date's incorrect or
> questionable behavior. I'm sure this is one of them. This code needs a
> general, systematic review.
to_date has always been impressively lax about error-checking its input.
While I wouldn't object to tightening that up, surely checking a
weekday name against the rest of the date should be very far down the
priority list of checks to make.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-02-21 17:27:59 | Re: about date/time parser |
| Previous Message | Tom Lane | 2008-02-21 17:13:18 | Re: VARATT_EXTERNAL_GET_POINTER is not quite there yet |