DROP OPERATOR id ( lefttype | NONE, righttype | NONE)
Use this parameter to provide the identifier of an existing operator you wish to remove.
This parameter takes the operator's left argument type (use "NONE" if the operator does not have a left argument).
This parameter takes the operator's left argument type (use "NONE" if the operator does not have a left argument).
This message is displayed if the command is successful.
This error is displayed if the binary operator you specified does not exist.
This message is displayed if the operator you specified does not exist.
This message is displayed if the right unary operator you specified does not exist.
Use the DROP OPERATOR command to remove an existing operator from the database. This command can only be used upon an operator if the current user is the owner.
 | Warning |
|---|---|
Removing an operator that has access methods or operator classes which rely on it can cause problems; make sure you note what these classes and methods are (if anything relies on this operator) before dropping it. |