Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable
Дата
Msg-id CAKFQuwZPmXux++yVkN312cGKfZst1kqFMEjQLjGQb0wj6GwFRQ@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONEshould not be comparable  (edpeur@gmail.com)
Ответы Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable
Список pgsql-bugs
Дерево обсуждения
On Tue, Oct 3, 2017 at 2:19 PM, Eduardo Pérez Ureta <edpeur@gmail.com> wrote:
I did not know that the SQL standard was so broken. Maybe it is time to consider only following the SQL standard in its non-broken parts, like other SQL databases do.

​It has its quirks but the two you have fixated on seem easy enough to avoid.

At this point we've already decided that being conforming is generally a virtue; especially since I'd assume that at least some "other SQL databases" also conform to these same rules.  Deciding to become more strict (as opposed to starting out that way) requires significant benefit.


​David J.​

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14841: Remove TIME WITH TIME ZONE type
Следующее
От: John R Pierce
Дата:
Сообщение: Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable