asia123321@xxxxx 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
