I'm trying to understand a difference in behavior on Dataiku and my external tool Dbeaver. I'm runing the same queries on the same database (PostGreSQL), one on Dataiku SQL recipe the other on Dbeaver.
Here is the first request:
select extract(day from date1-date2) as delai
On Dbeaver this syntax is not accepted it says : ERROR: function pg_catalog.date_part(unknown, integer) does not exist.
On Dataiku, it works.
I tried this second request:
select date1-date2 as delai
and further in the script try to compare delai with an integer
On Dbeaver, it works and makes the comparison.
On Dataiku, the logger returns: ERROR: operator does not exist: interval <= integer Hint: No operator matches the given name and argument types.
Why such different behavior since I'm working on the same database ?