Re: BUG #6231: weird to_timestamp behaviour with out of range values - Mailing list pgsql-bugs

From Stephen Frost
Subject Re: BUG #6231: weird to_timestamp behaviour with out of range values
Date
Msg-id 20111002000023.GC12765@tamriel.snowman.net
Whole thread Raw
In response to Re: BUG #6231: weird to_timestamp behaviour with out of range values  (Henk Enting <h.d.enting@mgrid.net>)
List pgsql-bugs
* Henk Enting (h.d.enting@mgrid.net) wrote:
> But still, I think the to_timestamp should throw an error if I put in
> something like '21-21-2011'.

I agree completely, this is a pretty big bug in my opinion.  We don't
accept invalid or garbage timestamps in the input function, I don't see
any reason why we should be allowing it in to_timestamp().  If the
values at the 'MM' location are outside of the valid range, we should be
throwing an error.

    Thanks,

        Stephen

pgsql-bugs by date:

Previous
From: Evan Martin
Date:
Subject: Re: BUG #6235: Delete fails with ON DELETE rule on inherited table
Next
From: Magnus Hagander
Date:
Subject: Re: [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe