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  (Martin Varady <martin.varady@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ozan Kahramanogullari
Дата:
Сообщение: psql on Mac
Следующее
От: Martin Varady
Дата:
Сообщение: Re: BUG #15445: Difference between two dates is not an integer