granicus.if.org Git - postgresql/blob - doc/src/sgml/ref/drop_operator.sgml

   1 <REFENTRY ID="SQL-DROPOPERATOR">
   2  <REFMETA>
   3   <REFENTRYTITLE>
   4    DROP OPERATOR
   5   </REFENTRYTITLE>
   6   <REFMISCINFO>SQL - Language Statements</REFMISCINFO>
   7  </REFMETA>
   8  <REFNAMEDIV>
   9   <REFNAME>
  10    DROP OPERATOR
  11   </REFNAME>
  12   <REFPURPOSE>
  13    Removes an operator from the database
  14   </REFPURPOSE>
  15  </refnamediv>
  16
  17  <REFSYNOPSISDIV>
  18   <REFSYNOPSISDIVINFO>
  19    <DATE>1998-09-22</DATE>
  20   </REFSYNOPSISDIVINFO>
  21   <SYNOPSIS>
  22 DROP OPERATOR <REPLACEABLE CLASS="PARAMETER">id</REPLACEABLE> ( <REPLACEABLE CLASS="PARAMETER">type</REPLACEABLE> | NONE [,...] )
  23   </SYNOPSIS>
  24
  25   <REFSECT2 ID="R2-SQL-DROPOPERATOR-1">
  26    <REFSECT2INFO>
  27     <DATE>1998-09-22</DATE>
  28    </REFSECT2INFO>
  29    <TITLE>
  30     Inputs
  31    </TITLE>
  32    <PARA>
  33    </PARA>
  34        <VARIABLELIST>
  35         <VARLISTENTRY>
  36          <TERM>
  37           <replaceable class="parameter">id</replaceable>
  38          </TERM>
  39          <LISTITEM>
  40           <PARA>
  41           The identifier of an existing operator.
  42           </PARA>
  43          </LISTITEM>
  44         </VARLISTENTRY>
  45         <VARLISTENTRY>
  46          <TERM>
  47           <replaceable class="parameter">type</replaceable>
  48          </TERM>
  49          <LISTITEM>
  50           <PARA>
  51           The type of function parameters.
  52           </PARA>
  53          </LISTITEM>
  54         </VARLISTENTRY>
  55        </variablelist>
  56   </REFSECT2>
  57
  58   <REFSECT2 ID="R2-SQL-DROPOPERATOR-2">
  59    <REFSECT2INFO>
  60     <DATE>1998-09-22</DATE>
  61    </REFSECT2INFO>
  62    <TITLE>
  63     Outputs
  64    </TITLE>
  65    <PARA>
  66
  67        <VARIABLELIST>
  68         <VARLISTENTRY>
  69          <TERM>
  70           <ReturnValue>DROP</ReturnValue>
  71          </TERM>
  72          <LISTITEM>
  73           <PARA>
  74            The message returned if the command is successful.
  75           </PARA>
  76          </LISTITEM>
  77         </VARLISTENTRY>
  78         <VARLISTENTRY>
  79          <TERM>
  80           <ReturnValue>ERROR:  RemoveOperator: binary operator '<REPLACEABLE CLASS="PARAMETER">id</REPLACEABLE>' taking '<REPLACEABLE CLASS="PARAMETER">type1</REPLACEABLE>' and '<REPLACEABLE CLASS="PARAMETER">type2</REPLACEABLE>' does not exist</ReturnValue>
  81          </TERM>
  82          <LISTITEM>
  83           <PARA>
  84           This message occurs if the specified binary operator does not exist.
  85           </PARA>
  86          </LISTITEM>
  87         </VARLISTENTRY>
  88         <VARLISTENTRY>
  89          <TERM>
  90           <ReturnValue>ERROR:  RemoveOperator: left unary operator '<REPLACEABLE CLASS="PARAMETER">id</REPLACEABLE>' taking '<REPLACEABLE CLASS="PARAMETER">type</REPLACEABLE>' does not exist</ReturnValue>
  91          </TERM>
  92          <LISTITEM>
  93           <PARA>
  94           This message occurs if the specified left unary operator
  95  specified does not exist.
  96           </PARA>
  97          </LISTITEM>
  98         </VARLISTENTRY>
  99         <VARLISTENTRY>
 100          <TERM>
 101           <ReturnValue>ERROR:  RemoveOperator: right unary operator '<REPLACEABLE CLASS="PARAMETER">id</REPLACEABLE>' taking '<REPLACEABLE CLASS="PARAMETER">type</REPLACEABLE>' does not exist</ReturnValue>
 102          </TERM>
 103          <LISTITEM>
 104           <PARA>
 105           This message occurs if the specified right unary operator
 106  specified does not exist.
 107        </para>
 108       </listitem>
 109      </varlistentry>
 110     </VARIABLELIST>
 111    </para>
 112   </REFSECT2>
 113  </REFSYNOPSISDIV>
 114
 115  <REFSECT1 ID="R1-SQL-DROPOPERATOR-1">
 116   <REFSECT1INFO>
 117    <DATE>1998-09-22</DATE>
 118   </REFSECT1INFO>
 119   <TITLE>
 120    Description
 121   </TITLE>
 122   <PARA>
 123    The DROP OPERATOR statement drops an existing operator from the
 124    database.
 125    To execute this command you must be the owner of the operator.
 126   </PARA>
 127   <PARA>
 128    The left or right type of a left or right unary
 129    operator, respectively, may be specified as NONE.
 130   </PARA>
 131
 132   <REFSECT2 ID="R2-SQL-DROPOPERATOR-3">
 133    <REFSECT2INFO>
 134     <DATE>1998-09-22</DATE>
 135    </REFSECT2INFO>
 136    <TITLE>
 137     Notes
 138    </TITLE>
 139    <PARA>
 140     The <command>DROP OPERATOR</command> statement is a
 141 <productname>Postgres</productname>
 142     language extension.
 143    </PARA>
 144    <PARA>
 145     Refer to <command>CREATE OPERATOR</command> for
 146     information on how to create operators.
 147    </PARA>
 148    <PARA>
 149     It is the user's responsibility to remove any access methods and
 150     operator classes that rely on the deleted operator.
 151    </PARA>
 152   </REFSECT2>
 153  </refsect1>
 154
 155  <REFSECT1 ID="R1-SQL-DROPOPERATOR-2">
 156   <TITLE>
 157    Usage
 158   </TITLE>
 159   <PARA>
 160    Remove power operator <literal>a^n</literal> for <literal>int4</literal>:
 161   </PARA>
 162   <ProgramListing>
 163 DROP OPERATOR ^ (int4, int4);
 164   </ProgramListing>
 165   <PARA>
 166    Remove left unary operator <literal>!a</literal> for booleans:
 167   </PARA>
 168   <ProgramListing>
 169 DROP OPERATOR ! (none, bool);
 170   </ProgramListing>
 171   <PARA>
 172    Remove right unary factorial operator <literal>a!</literal> for
 173    <literal>int4</literal>:
 174   </PARA>
 175   <ProgramListing>
 176 DROP OPERATOR ! (int4, none);
 177   </ProgramListing>
 178  </REFSECT1>
 179
 180  <REFSECT1 ID="R1-SQL-DROPOPERATOR-3">
 181   <TITLE>
 182    Compatibility
 183   </TITLE>
 184   <PARA>
 185   </PARA>
 186
 187   <REFSECT2 ID="R2-SQL-DROPOPERATOR-4">
 188    <REFSECT2INFO>
 189     <DATE>1998-09-22</DATE>
 190    </REFSECT2INFO>
 191    <TITLE>
 192     SQL92
 193    </TITLE>
 194    <PARA>
 195    There is no <command>DROP OPERATOR</command> in <acronym>SQL92</acronym>.
 196    </PARA>
 197   </refsect2>
 198  </refsect1>
 199 </REFENTRY>
 200
 201 <!-- Keep this comment at the end of the file
 202 Local variables:
 203 mode: sgml
 204 sgml-omittag:t
 205 sgml-shorttag:t
 206 sgml-minimize-attributes:nil
 207 sgml-always-quote-attributes:t
 208 sgml-indent-step:1
 209 sgml-indent-data:t
 210 sgml-parent-document:nil
 211 sgml-default-dtd-file:"../reference.ced"
 212 sgml-exposed-tags:nil
 213 sgml-local-catalogs:"/usr/lib/sgml/catalog"
 214 sgml-local-ecat-files:nil
 215 End:
 216 -->