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

That was it, thank you so much. I'll check out what the impact of that is
during the migration process. Worse case I set it after the fact.

Thank You,
Martin

On Fri, Oct 19, 2018 at 11:03 AM Anthony Sotolongo <asotolongo(at)gmail(dot)com>
wrote:

> 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(dot)varady(at)gmail(dot)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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>
>>> Martin Varady <martin(dot)varady(at)gmail(dot)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
>>>
>>