Michael Fuhr <mike@fuhr.org> writes:
> The leading space is confusing to_timestamp():
> test=> SELECT to_timestamp(' 2004 12 17', 'YYYY MM DD');
> to_timestamp
> ---------------------
> 2171-11-06 06:00:00
I'd still say this is a bug. If to_timestamp can't match the input to
the pattern, it should throw an error, not silently return garbage.
regards, tom lane