View Single Post

   
  #8 (permalink)  
Old 04-15-2008, 09:04 PM
Brendan Jurd
 
Posts: n/a
Default Re: Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

On 7/18/07, Tom Lane <tgl@sss.pgh.pa.us> 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

Reply With Quote