DROP CAST -- remove a user-defined cast
DROP CAST ( sourcetype AS targettype)
[ CASCADE | RESTRICT ]
DROP CAST removes a previously defined cast.
To be able to drop a cast, you must own the source or the target
data type. These are the same privileges that are required to
create a cast.
The name of the source data type of the cast.
The name of the target data type of the cast.
These key words do not have any effect, since there are no
dependencies on casts.
Use CREATE CAST to create user-defined casts.
To drop the cast from type text to type int:
DROP CAST (text AS int4);
The DROP CAST command conforms to SQL99.
This file was copied from PostgreSQL 7.3.1 help system.