Re: date validation problem - Mailing list pgsql-bugs

From Michael van Elst
Subject Re: date validation problem
Date
Msg-id 20031229142738.GA13819@serpens.de
Whole thread Raw
In response to Re: date validation problem  (Theodore Petrosky <tedpet5@yahoo.com>)
Responses Re: date validation problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Mon, Dec 29, 2003 at 05:47:56AM -0800, Theodore Petrosky wrote:
>
> I don't see the problem... you are specifying the 66th
> day of the 55th month in the year 5555. just a cursory
> glance says that 48 months is 4 years... that gives
> the year as 5559. try your example with real numbers
> (unless these are real)

(Assuming a typo, the select() showed the 665th day).

But there is no 55th month and no 66th day of that month,
the conversion should simply fail and abort the transaction
with an error, shouldn't it ?

--
                                Michael van Elst
Internet: mlelstv@serpens.de
                                "A potential Snark may lurk in every tree."

pgsql-bugs by date:

Previous
From: Theodore Petrosky
Date:
Subject: Re: date validation problem
Next
From: Tom Lane
Date:
Subject: Re: date validation problem