1
<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/drop_cast.sgml,v 1.6 2003-11-29 19:51:38 pgsql Exp $ -->
3
<refentry id="SQL-DROPCAST">
5
<refentrytitle id="SQL-DROPCAST-TITLE">DROP CAST</refentrytitle>
6
<refmiscinfo>SQL - Language Statements</refmiscinfo>
10
<refname>DROP CAST</refname>
11
<refpurpose>remove a cast</refpurpose>
14
<indexterm zone="sql-dropcast">
15
<primary>DROP CAST</primary>
20
DROP CAST (<replaceable>sourcetype</replaceable> AS <replaceable>targettype</replaceable>) [ CASCADE | RESTRICT ]
24
<refsect1 id="sql-dropcast-description">
25
<title>Description</title>
28
<command>DROP CAST</command> removes a previously defined cast.
32
To be able to drop a cast, you must own the source or the target
33
data type. These are the same privileges that are required to
39
<title>Parameters</title>
43
<term><replaceable>sourcetype</replaceable></term>
47
The name of the source data type of the cast.
53
<term><replaceable>targettype</replaceable></term>
57
The name of the target data type of the cast.
63
<term><literal>CASCADE</literal></term>
64
<term><literal>RESTRICT</literal></term>
68
These key words do not have any effect, since there are no
69
dependencies on casts.
76
<refsect1 id="sql-dropcast-examples">
77
<title>Examples</title>
80
To drop the cast from type <type>text</type> to type <type>int</type>:
82
DROP CAST (text AS int);
87
<refsect1 id="sql-dropcast-compat">
88
<title>Compatibility</title>
91
The <command>DROP CAST</command> command conforms to the SQL standard.
96
<title>See Also</title>
98
<simplelist type="inline">
99
<member><xref linkend="sql-createcast" endterm="sql-createcast-title"></member>
105
<!-- Keep this comment at the end of the file
110
sgml-minimize-attributes:nil
111
sgml-always-quote-attributes:t
114
sgml-parent-document:nil
115
sgml-default-dtd-file:"../reference.ced"
116
sgml-exposed-tags:nil
117
sgml-local-catalogs:("/usr/lib/sgml/catalog")
118
sgml-local-ecat-files:nil