Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable
Date
Msg-id CAKFQuwZPmXux++yVkN312cGKfZst1kqFMEjQLjGQb0wj6GwFRQ@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONEshould not be comparable  (edpeur@gmail.com)
Responses Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable  (John R Pierce <pierce@hogranch.com>)
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14841: Remove TIME WITH TIME ZONE type
Next
From: John R Pierce
Date:
Subject: Re: [BUGS] BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUTTIMEZONE should not be comparable