I came across with a strange issue in postgres. I have two databases create in two different periods.
Both are running in the same PostrgreSql 9.6 version in the same machine. When I run the query SELECT now() + 30
in database 1 -> Its working properly.
The same query I am copy paste in the second database, its giving error: operator does not exist: timestamp with time zone + integer
in PostgreSql
Can some one guide me on this.
Best Answer
Maybe someone created the operator with those types in one database, but not in the other one.