From: | Anthony Sotolongo <asotolongo(at)gmail(dot)com> |
---|---|
To: | Martin Varady <martin(dot)varady(at)gmail(dot)com> |
Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us, sk(at)zsrv(dot)org, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15445: Difference between two dates is not an integer |
Date: | 2018-10-19 15:02:58 |
Message-ID: | CAASDfF1-oFHH6R+CSqQQNYe4T5fO-ZdM9_MMd1_SayNoR3wAPw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Varady | 2018-10-19 15:52:59 | Re: BUG #15445: Difference between two dates is not an integer |
Previous Message | Ozan Kahramanogullari | 2018-10-19 14:56:15 | psql on Mac |