| From: | Michael van Elst <mlelstv(at)serpens(dot)de> |
|---|---|
| To: | Theodore Petrosky <tedpet5(at)yahoo(dot)com> |
| Cc: | Sh A Guru Prasad <guru(at)ap(dot)nic(dot)in>, pgsql -bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: date validation problem |
| Date: | 2003-12-29 14:27:38 |
| Message-ID: | 20031229142738.GA13819@serpens.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)serpens(dot)de
"A potential Snark may lurk in every tree."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-29 16:04:06 | Re: date validation problem |
| Previous Message | Theodore Petrosky | 2003-12-29 13:47:56 | Re: date validation problem |