On Sun, Sep 19, 2004 at 12:31:26PM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> 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.
Agreed that it's a bug. Returning garbage violates the Principle
of Least Surprise.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
