drop_operator(7) - BetterMan

drop_operator(7)

remove an operator

distrodataset 2026-04-01T06:19:02Z+debian+ec4110e+mandoc:1.14.6-4

Synopsis

DROP OPERATOR [ IF EXISTS ] 
name
 ( { 
left_type
 | NONE } , 
right_type
 ) [, ...] [ CASCADE | RESTRICT ]

—

NAME

DROP_OPERATOR - remove an operator

bash

DROP OPERATOR [ IF EXISTS ] \nname\n ( { \nleft_type\n | NONE } , \nright_type\n ) [, ...] [ CASCADE | RESTRICT ]

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

IF EXISTS

name

left_type

right_type

CASCADE

RESTRICT

Remove the power operator a^b for type integer:

bash

DROP OPERATOR ^ (integer, integer);

Remove the bitwise-complement prefix operator ~b for type bit:

bash

DROP OPERATOR ~ (none, bit);

Remove multiple operators in one command:

bash

DROP OPERATOR ~ (none, bit), ^ (integer, integer);

There is no DROP OPERATOR statement in the SQL standard.