Re: BUG #1630: Wrong conversion in to_date() function. See

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, "Ariel E(dot)" Carná/Elizabeth Sosa <acarna(at)tarifar(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1630: Wrong conversion in to_date() function. See
Date: 2005-05-02 20:33:40
Message-ID: 1115066020.5898.45.camel@petra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, 2005-04-27 at 10:53 -0400, Tom Lane wrote:
> Michael Fuhr <mike(at)fuhr(dot)org> writes:
> > If anything I'd expect 2005-02-32 to be rejected as invalid, but I
> > don't know the history or rationale behind to_date's behavior.
>
> It is rejected by the standard date input converter:
>
> regression=# select '2005-02-32'::date;
> ERROR: date/time field value out of range: "2005-02-32"
> HINT: Perhaps you need a different "datestyle" setting.
>
> However we consider that to_date() exists to be Oracle compatible,
> and so I would regard this as a bug if and only if Oracle does
> something different with the same input. Anyone know?

It's "almost" bug. And it's in TODO (but it's really long todo..:-( I
think to_date/timestamp() should be more pedantic.

Karel

PS. for volunteers for the work on new generation of to_char/date():
http://people.redhat.com/kzak/libfmt/libfmt-0.2-03262005.tar.gz

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Achilleus Mantzios 2005-05-03 06:12:45 Re: BUG #1632: Several jailed PostgreSQL instances.
Previous Message Jim C. Nasby 2005-05-01 18:37:10 Re: looks like apple fixed /etc/rc