Re: Update existing system explicit cast to make it implicit

asia123321@op.pl writes:
> I am trying to use bit(1) datatype with existing application that used int datatype before.
> So I tried to create implicit cast that will allow me not to make code modifications and wanted to create implicit
cast"int2bit", but it turned out that there is already system cast. 
> Unfortunately this cast is explicit and I need to make it implicit (it can be made implicit only for one schema).

You will likely find that this is a really bad idea.  Implicit
casts between fundamentally different datatypes are *dangerous*.
They tend to result in either surprising query behaviors or unexpected
"operator is not unique" failures.  Fixing the app would be a lot safer
in the long run.

> My question is that if there is any official way to overwrite this attribute

No.  If you're intent on breaking things, hacking the catalog is what to do.

            regards, tom lane