[email protected] 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
