Description

DROP CAST: deletes a previously defined cast.

Note To delete a cast, you must own the source or the target data type.

Synopsis

DROP CAST [ IF EXISTS ] (source_type AS target_type)

Parameters

  • IF EXISTS: specifies that a notification instead of an error is returned if the cast does not exist.
  • source_type: the name of the source data type of the cast.
  • target_type: the name of the target data type of the cast.

Examples

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

For more information about the DROP CAST statement, see DROP CAST of PostgreSQL.