Thread: ALTER CAST

Hi, any reason not to implement an ALTER CAST statement?

the situation where i need it is for migration... i'm currently
migrating an application from sql server. and in sql server the cast
from int to bool seems like it is implicit and the application makes
use of that...now, instead of changing the whole application is far
more convenient to alter the cast (int as bool) to make it implicit
but the only way to do it is via alter catalogs...

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> Hi, any reason not to implement an ALTER CAST statement?

Mainly, because we don't really *want* every thinks-he-knows-something
DBA fooling around with the built-in casts.  If he actually knows enough
to know whether it's safe, then he knows enough to do it by poking the
catalogs.
        regards, tom lane