DROP OPERATOR - Removes an operator from the database


SYNOPSIS

       DROP OPERATOR id ( lefttype | NONE , righttype | NONE )

   INPUTS
       id     The identifier of an existing operator.

       lefttype
              The  type  of  the  operator's left argument; write
              NONE if the operator has no left argument.

       righttype
              The type of the operator's  right  argument;  write
              NONE if the operator has no right argument.

   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  left unary operator
              specified does not exist.

       ERROR: RemoveOperator: right unary operator 'oper' taking
              'type' does not exist
              This message occurs if  the  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, must be specified as NONE.

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

       Refer to CREATE OPERATOR [create_operator(l)] for informa­
       tion on how to create operators.

       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.


Man(1) output converted with man2html