DROP CAST
Section: PostgreSQL 15.6 Documentation (7)
Updated: 2024
Index
Return to Main Contents
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))
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- PARAMETERS
-
- EXAMPLES
-
- COMPATIBILITY
-
- SEE ALSO
-
This document was created by
man2html,
using the manual pages.
Time: 12:43:35 GMT, April 26, 2024