[BUGS] BUG #14632: Plus and minus operators inconsistency with leap yearsand year intervals.

Поиск
Список
Период
Сортировка
От pietro.pugni@gmail.com
Тема [BUGS] BUG #14632: Plus and minus operators inconsistency with leap yearsand year intervals.
Дата
Msg-id 20170426182322.24371.95224@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals.  (Marko Tiikkaja <marko@joh.to>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      14632
Logged by:          Pietro Pugni
Email address:      pietro.pugni@gmail.com
PostgreSQL version: 9.6.2
Operating system:   Ubuntu 16.04.2 LTS
Description:

The following query:SELECT '1912-02-29'::date + '10 years'::interval

returns:'1922-02-28 00:00:00'

while the reverse operation:SELECT '1922-02-28'::date - '10 years'::interval

returns:'1912-02-28 00:00:00'

instead of '1912-02-29 00:00:00'.




--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [BUGS] Concurrent ALTER SEQUENCE RESTART Regression
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals.