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

Hi Martin if you are using EDB Postgres this operation require set edb_redwood_date = false 

And then the operator - with date Will be like PostgreSQL native

Regards

El vie., 19 de oct. de 2018 11:56 a.m., Martin Varady <martin.varady@gmail.com> escribió:

Not sure how to close my logged bug. But its safe to say its not a defect. Thank You for your help.

On Fri, Oct 19, 2018 at 10:26 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

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