1DROP OPERATOR(7)                 SQL Commands                 DROP OPERATOR(7)
2
3
4

NAME

6       DROP OPERATOR - remove an operator
7
8

SYNOPSIS

10       DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

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

PARAMETERS

18       IF EXISTS
19              Do not throw an error if the operator does not exist.  A  notice
20              is issued in this case.
21
22       name   The name (optionally schema-qualified) of an existing operator.
23
24       lefttype
25              The  data type of the operator's left operand; write NONE if the
26              operator has no left operand.
27
28       righttype
29              The data type of the operator's right operand; write NONE if the
30              operator has no right operand.
31
32       CASCADE
33              Automatically drop objects that depend on the operator.
34
35       RESTRICT
36              Refuse to drop the operator if any objects depend on it. This is
37              the default.
38

EXAMPLES

40       Remove the power operator a^b for type integer:
41
42       DROP OPERATOR ^ (integer, integer);
43
44
45       Remove the left unary bitwise complement operator ~b for type bit:
46
47       DROP OPERATOR ~ (none, bit);
48
49
50       Remove the right unary factorial operator x!  for type bigint:
51
52       DROP OPERATOR ! (bigint, none);
53
54

COMPATIBILITY

56       There is no DROP OPERATOR statement in the SQL standard.
57

SEE ALSO

59       CREATE  OPERATOR  [create_operator(7)],  ALTER  OPERATOR  [alter_opera‐
60       tor(7)]
61
62
63
64SQL - Language Statements         2011-09-22                  DROP OPERATOR(7)