On 7/18/07, Tom Lane <[EMAIL PROTECTED]> wrote:
This is all good but I think that self-inconsistent format strings are not really the main source of to_date problems. Most of the complaints I've seen arise from to_date plowing ahead to deliver a ridiculous answer when the input data string doesn't match the format. I'd like to see the code try a little harder to validate the input data.
Agreed, but so far it doesn't look like there's much overlap between the parsing and validating code and the stuff I'm playing with. I'll keep an eye out for any opportunities to improve on this, but it might end up being a separate TODO. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate