Re: BUG #15445: Difference between two dates is not an integer
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Martin Varady <martin.varady@gmail.com>
Cc: sk@zsrv.org, pgsql-bugs@lists.postgresql.org
Date: 2018-10-19T14:26:08Z
Lists: pgsql-bugs
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