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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Varady <martin(dot)varady(at)gmail(dot)com>
Cc: 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 14:26:08
Message-ID: 32675.1539959168@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Varady 2018-10-19 14:37:22 Re: BUG #15445: Difference between two dates is not an integer
Previous Message Martin Varady 2018-10-19 14:05:46 Re: BUG #15445: Difference between two dates is not an integer