Hi,
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).
My question is that if there is any official way to overwrite this attribute instead of performing following query:
update pg_cast set castcontext = 'i' where oid in (
select c.oid
from pg_cast c
inner join pg_type src on src.oid = c.castsource
inner join pg_type tgt on tgt.oid = c.casttarget
where src.typname like 'int%' and tgt.typname like 'bit%')
Thank you in advance for advice.
Asia
