NameDROP CAST -- remove a user-defined cast SynopsisDROP CAST (sourcetype AS targettype)
[ CASCADE | RESTRICT ]Description 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. Parameters - sourcetype
The name of the source data type of the cast. - targettype
The name of the target data type of the cast. - CASCADE
RESTRICT These key words do not have any effect, since there are no dependencies on casts.
Notes Use CREATE CAST to create user-defined casts. Examples To drop the cast from type text to type int: DROP CAST (text AS int4); Compatibility The DROP CAST command conforms to SQL99. |
