Stephen Frost <sfrost@snowman.net> 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