> However that still leaves the original complaint around (at least IMHO):
> select to_timestamp('AN', 'AM');
> ERROR: invalid AM/PM string
> select to_timestamp('11:47 PM 27 Sep a2008', 'HH:MI PM DD Mon YYYY');
> ERROR: invalid value for "YYYY" in source string
Yeah, it would be a lot better if it said
ERROR: invalid value for "YYYY": "a2008"
The DETAIL is good too, but it's no substitute for showing the exact
substring that the code is unhappy about.
regards, tom lane