Re: BUG #15445: Difference between two dates is not an integer
| От | Anthony Sotolongo |
|---|---|
| Тема | Re: BUG #15445: Difference between two dates is not an integer |
| Дата | |
| Msg-id | CAASDfF1-oFHH6R+CSqQQNYe4T5fO-ZdM9_MMd1_SayNoR3wAPw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #15445: Difference between two dates is not an integer (Martin Varady <martin.varady@gmail.com>) |
| Ответы |
Re: BUG #15445: Difference between two dates is not an integer
|
| Список | 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
В списке pgsql-bugs по дате отправления: