Re: BUG #15445: Difference between two dates is not an integer - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15445: Difference between two dates is not an integer
Date
Msg-id 32675.1539959168@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15445: Difference between two dates is not an integer  (Martin Varady <martin.varady@gmail.com>)
Responses Re: BUG #15445: Difference between two dates is not an integer  (Martin Varady <martin.varady@gmail.com>)
List pgsql-bugs
Martin Varady <martin.varady@gmail.com> writes:
> I got what you would expect but still doesn't work. It is the enterpriseDB
> version we bought for Oracle to Postgres conversions.
> "EnterpriseDB 10.4.9, compiled by Visual C++ build 1800, 64-bit"

Well, you should have a word with EDB then, but what it sounds like
is they install a nondefault date - date operator, or possibly remove
PG's standard one so that timestamp - timestamp gets chosen instead.
Which is probably reasonable if your goal is compatibility with
Oracle.

            regards, tom lane


pgsql-bugs by date:

Previous
From: Martin Varady
Date:
Subject: Re: BUG #15445: Difference between two dates is not an integer
Next
From: Martin Varady
Date:
Subject: Re: BUG #15445: Difference between two dates is not an integer