Re: BUG #18445: date_part / extract range for hours do not match documentation

Поиск
Список
Период
Сортировка
От Marek Läll
Тема Re: BUG #18445: date_part / extract range for hours do not match documentation
Дата
Msg-id CADDPzFRkqATofspRzEBgnMVRUL8-JDu=3OO-DndeQnmKDMAfXg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18445: date_part / extract range for hours do not match documentation  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: BUG #18445: date_part / extract range for hours do not match documentation  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: BUG #18445: date_part / extract range for hours do not match documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
We tend not to introduce breaking changes if the only motivation is to be consistent.
 
Other mistakes are minor, but why is time '24:00:00' allowed, and it's actually 00:00:00 of the next day, that's something I'd like to read a well-argued design decision.
It's like months 1 through 12, and just in case, we also allow month 13, which represents January of the next year. But month 14 is not allowed, which could represent February of the next year.
Could you share the rationale behind this decision?

Marek Läll

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

Предыдущее
От: "Kumar, Devesh"
Дата:
Сообщение: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #18445: date_part / extract range for hours do not match documentation