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

NAME

6       DROP OPERATOR FAMILY - remove an operator family
7
8

SYNOPSIS

10       DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

14       DROP  OPERATOR  FAMILY  drops  an existing operator family.  To execute
15       this command you must be the owner of the operator family.
16
17       DROP OPERATOR FAMILY includes dropping any operator  classes  contained
18       in  the  family, but it does not drop any of the operators or functions
19       referenced by the family. If there are any indexes depending on  opera‐
20       tor classes within the family, you will need to specify CASCADE for the
21       drop to complete.
22

PARAMETERS

24       IF EXISTS
25              Do not throw an error if the operator family does not exist.   A
26              notice is issued in this case.
27
28       name   The  name  (optionally schema-qualified) of an existing operator
29              family.
30
31       index_method
32              The name of the index access method the operator family is for.
33
34       CASCADE
35              Automatically drop objects that depend on the operator family.
36
37       RESTRICT
38              Refuse to drop the operator family if any objects depend on  it.
39              This is the default.
40

EXAMPLES

42       Remove the B-tree operator family float_ops:
43
44       DROP OPERATOR FAMILY float_ops USING btree;
45
46       This  command  will  not succeed if there are any existing indexes that
47       use operator classes within  the  family.  Add  CASCADE  to  drop  such
48       indexes along with the operator family.
49

COMPATIBILITY

51       There is no DROP OPERATOR FAMILY statement in the SQL standard.
52

SEE ALSO

54       ALTER  OPERATOR FAMILY [alter_operator_family(7)], CREATE OPERATOR FAM‐
55       ILY [create_operator_family(7)],  ALTER  OPERATOR  CLASS  [alter_opera‐
56       tor_class(7)],  CREATE  OPERATOR CLASS [create_operator_class(7)], DROP
57       OPERATOR CLASS [drop_operator_class(7)]
58
59
60
61SQL - Language Statements         2011-09-22           DROP OPERATOR FAMILY(7)
Impressum