Version: 1.0.16

DROP CAST

DROP CAST — remove a cast

Synopsis

DROP CAST [ IF EXISTS ] (source_type AS target_type) [ 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. This is the same privilege required to create a cast.

IF EXISTS

Do not throw an error if the cast does not exist. A notice is issued in this case.

source_type

The name of the source data type of the cast.

target_type

The name of the target data type of the cast.

CASCADE

RESTRICT

These key words have no effect, since there are no dependencies on casts.

# To remove the cast from type text to type int:

DROP CAST (text AS int);