Re: BUG #15445: Difference between two dates is not an integer

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
>>
>