DROP OPERATOR
Function
DROP OPERATOR deletes an operator.
Precautions
The DROP OPERATOR statement deletes an existing operator from the database. To execute this command, you must be the owner of the operator.
Syntax
DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , { right_type | NONE } ) [ CASCADE | RESTRICT ]
Parameter Description
IF EXISTS
Do not throw an error if the specified operator does not exist. A notice is issued in this case.
name
Name (optionally schema-qualified) of an existing operator.
left_type
Type of the left operand for the operator. If no, set this parameter to NONE.
right_type
Type of the right operand for the operator. If no, set this parameter to NONE.
CASCADE
Automatically drops all objects that depend on this operator.
RESTRICT
Refuses to delete the operator if any objects depend on it. This is a default parameter.
Example
Delete the power operator a^b used for integer.
DROP OPERATOR ^ (integer, integer);
Delete the left unary bit operator ~b for the bit type.
DROP OPERATOR ~ (none, bit);
Delete the factorial x used for bigint.:
DROP OPERATOR ! (bigint, none);
Compatibility
The SQL standard does not contain the DROP OPERATOR statement.