DROP_OPERATOR(l)                                 DROP_OPERATOR(l)

NAME
       DROP OPERATOR - Removes an operator from the database

SYNOPSIS
       DROP OPERATOR id ( type | NONE [,...] )

   INPUTS
       id     The identifier of an existing operator.

       type   The type of function parameters.

   OUTPUTS
       DROP   The  message returned if the command is successful.

       ERROR: RemoveOperator: binary operator 'oper' taking
              'type'  and 'type2' does not exist
              This message occurs if the specified binary  opera-
              tor does not exist.

       ERROR:  RemoveOperator:  left unary operator 'oper' taking
              'type' does not exist
              This  message  occurs  if  the specified left unary
              operator specified does not exist.

       ERROR: RemoveOperator: right unary operator 'oper' taking
              'type' does not exist
              This message occurs if the  specified  right  unary
              operator specified does not exist.

DESCRIPTION
       DROP   OPERATOR   drops  an  existing  operator  from  the
       database.  To execute this command you must be  the  owner
       of the operator.

       The  left or right type of a left or right unary operator,
       respectively, may be specified as NONE.

   NOTES
       The DROP OPERATOR statement is a Postgres language  exten-
       sion.

       Refer to create_operator(l) for information on how to cre-
       ate operators.

       It is the user's responsibility to remove any access meth-
       ods  and  operator classes that rely on the deleted opera-
       tor.

USAGE
       Remove power operator a^n for int4:

       DROP OPERATOR ^ (int4, int4);

       Remove left unary negation operator (b !) for booleans:

       DROP OPERATOR ! (none, bool);

       Remove right unary factorial operator (! i) for int4:

       DROP OPERATOR ! (int4, none);

COMPATIBILITY
   SQL92
       There is no DROP OPERATOR in SQL92.

SQL - Language Statements 15 August 1999                        1