t
 Title: DROP CAST
 Author: The PostgreSQL Global Development Group
 Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
 Date: 2021
 Manual: PostgreSQL 10.19 Documentation
 Source: PostgreSQL 10.19
 Language: English

 "DROP CAST" "7" "2021" "PostgreSQL 10.19" "PostgreSQL 10.19 Documentation"
 -----------------------------------------------------------------
 * Define some portability stuff
 -----------------------------------------------------------------
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 http://bugs.debian.org/507673
 http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 -----------------------------------------------------------------
 * set default formatting
 -----------------------------------------------------------------
 disable hyphenation
 disable justification (adjust text to left margin only)
 -----------------------------------------------------------------
 * MAIN CONTENT STARTS HERE *
 -----------------------------------------------------------------
 "NAME"
DROP_CAST - remove a cast

 "SYNOPSIS"
DROP CAST [ IF EXISTS ] (source_type AS target_type) [ 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"

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 do not have any effect, since there are no dependencies on casts.



 "EXAMPLES"

To drop the cast from type
text
to type
int:


.\}

DROP CAST (text AS int);




.\}

 "COMPATIBILITY"

The
DROP CAST
command conforms to the SQL standard.

 "SEE ALSO"
CREATE CAST (CREATE_CAST(7))