| <!-- $PostgreSQL: pgsql/doc/src/sgml/ref/drop_conversion.sgml,v 1.10 2006/09/16 00:30:18 momjian Exp $ --> |
| |
| <refentry id="SQL-DROPCONVERSION"> |
| <refmeta> |
| <refentrytitle id="SQL-DROPCONVERSION-TITLE">DROP CONVERSION</refentrytitle> |
| <refmiscinfo>SQL - Language Statements</refmiscinfo> |
| </refmeta> |
| |
| <refnamediv> |
| <refname>DROP CONVERSION</refname> |
| <refpurpose>remove a conversion</refpurpose> |
| </refnamediv> |
| |
| <indexterm zone="sql-dropconversion"> |
| <primary>DROP CONVERSION</primary> |
| </indexterm> |
| |
| <refsynopsisdiv> |
| <synopsis> |
| DROP CONVERSION [ IF EXISTS ] <replaceable>name</replaceable> [ CASCADE | RESTRICT ] |
| </synopsis> |
| </refsynopsisdiv> |
| |
| <refsect1 id="sql-dropconversion-description"> |
| <title>Description</title> |
| |
| <para> |
| <command>DROP CONVERSION</command> removes a previously defined conversion. |
| To be able to drop a conversion, you must own the conversion. |
| </para> |
| </refsect1> |
| |
| <refsect1> |
| <title>Parameters</title> |
| |
| <variablelist> |
| <varlistentry> |
| <term><literal>IF EXISTS</literal></term> |
| <listitem> |
| <para> |
| Do not throw an error if the conversion does not exist. |
| A notice is issued in this case. |
| </para> |
| </listitem> |
| </varlistentry> |
| |
| <varlistentry> |
| <term><replaceable>name</replaceable></term> |
| |
| <listitem> |
| <para> |
| The name of the conversion. The conversion name may be |
| schema-qualified. |
| </para> |
| </listitem> |
| </varlistentry> |
| |
| <varlistentry> |
| <term><literal>CASCADE</literal></term> |
| <term><literal>RESTRICT</literal></term> |
| |
| <listitem> |
| <para> |
| These key words do not have any effect, since there are no |
| dependencies on conversions. |
| </para> |
| </listitem> |
| </varlistentry> |
| </variablelist> |
| </refsect1> |
| |
| <refsect1 id="sql-dropconversion-examples"> |
| <title>Examples</title> |
| |
| <para> |
| To drop the conversion named <literal>myname</>: |
| <programlisting> |
| DROP CONVERSION myname; |
| </programlisting> |
| </para> |
| </refsect1> |
| |
| <refsect1 id="sql-dropconversion-compat"> |
| <title>Compatibility</title> |
| |
| <para> |
| There is no <command>DROP CONVERSION</command> statement in the SQL |
| standard. |
| </para> |
| </refsect1> |
| |
| <refsect1> |
| <title>See Also</title> |
| |
| <simplelist type="inline"> |
| <member><xref linkend="sql-alterconversion" endterm="sql-alterconversion-title"></member> |
| <member><xref linkend="sql-createconversion" endterm="sql-createconversion-title"></member> |
| </simplelist> |
| </refsect1> |
| |
| </refentry> |