Date calculation produces wrong output with 7.02

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Date calculation produces wrong output with 7.02
Дата
Msg-id 200102231718.f1NHIFd84626@hub.org
обсуждение исходный текст
Ответы Re: Date calculation produces wrong output with 7.02  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Mark Stosberg (mark@summersault.com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Date calculation produces wrong output with 7.02

Long Description
I use Postgres nearly every day and am very appreciative of the project.

I think this example will my bug:

[PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96]
cascade=> select date(CURRENT_DATE + ('30 days'::reltime));
      date
----------
9097-10-20

#############

It's quite likely my "date math" syntax is wrong, but it seems that Postgres should either return the right result, or
letme know something is fault.  

Sample Code


No file was uploaded with this report

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Rainer Mager"
Дата:
Сообщение: RE: Problem with 7.0.3 dump -> 7.1b4 restore
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Date calculation produces wrong output with 7.02