Stephen Frost <[EMAIL PROTECTED]> writes: > I guess my example was lacking, I'm sure there are cases where the > text->date casting will end up being wrong or some date style won't be > accepted. If the above was 'January 10th, 2003, October 1st, 2003, > January 1st, 2003', for example. Thinking back I think that might have > been the situation I was thinking about (conflicting mdy and dmy) and > would have made more sense as an example.
Then what are you after, some magically prescient input mode that will guess the correct interpretation? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html