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