Re: Timestamp operator error

"Josh Berkus" <josh(at)agliodbs(dot)com> writes:
> Is there a way, for example, that I could disallow the TIMESTAMP -->
> DATE implicit conversion in my code?

Well, you could delete the date(timestamp) function from pg_proc.
However, that would prevent getting from timestamp to date even
with an explicit cast --- so you might want to put it back after
you've found all the trouble spots.

My approach would be to rename rather than delete the pg_proc entry (say
update "date" to "datexxx" in proname); then you could reverse the
rename after finding your problems. On the other hand, if you're doing
the testing in a deletable temporary database, this isn't a problem.

regards, tom lane