View Single Post

   
  #7 (permalink)  
Old 04-15-2008, 10:03 PM
Tom Lane
 
Posts: n/a
Default Re: Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

"Brendan Jurd" <direvus@gmail.com> writes:
>> * Fix to_date()-related functions to consistently issue errors
>> http://archives.postgresql.org/pgsql...2/msg00915.php


> I'm now taking another run at this issue. Here's what I've got in mind.


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.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote