How to use DROP CAST to delete a defined type cast - - Alibaba Cloud Documentation Center

Deletes a defined type cast.

Prerequisites

You have access to source or target data types.

DROP CAST [ IF EXISTS ] (source_type AS target_type)

The table below describes the parameters:

Parameter	Description
IF EXISTS	Returns a notice rather than an error if the cast does not exist.
source_type	The source data type.
target_type	The target data type.

DROP CAST [ IF EXISTS ] (source_type AS target_type)

DROP CAST IF EXISTS (text AS timestamptz);
DROP CAST IF EXISTS (text AS integer);

For more information, see DROP CAST of PostgreSQL.