Re: date validation problem

Поиск
Список
Период
Сортировка
От Michael van Elst
Тема Re: date validation problem
Дата
Msg-id 20031229142738.GA13819@serpens.de
обсуждение исходный текст
Ответ на Re: date validation problem  (Theodore Petrosky <tedpet5@yahoo.com>)
Ответы Re: date validation problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Theodore Petrosky
Дата:
Сообщение: Re: date validation problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: date validation problem