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

NAME

6       CREATE OPERATOR FAMILY - define a new operator family
7
8

SYNOPSIS

10       CREATE OPERATOR FAMILY name USING index_method
11
12

DESCRIPTION

14       CREATE OPERATOR FAMILY creates a new operator family.  An operator fam‐
15       ily defines a collection of related operator classes, and perhaps  some
16       additional  operators  and  support  functions that are compatible with
17       these operator classes but not essential for  the  functioning  of  any
18       individual  index.  (Operators  and  functions  that  are  essential to
19       indexes should be grouped within the relevant  operator  class,  rather
20       than  being  ``loose'' in the operator family.  Typically, single-data-
21       type operators are bound to  operator  classes,  while  cross-data-type
22       operators  can  be  loose  in  an  operator  family containing operator
23       classes for both data types.)
24
25       The new operator family is initially empty. It should be  populated  by
26       issuing  subsequent  CREATE  OPERATOR  CLASS  commands to add contained
27       operator classes, and optionally ALTER OPERATOR FAMILY commands to  add
28       ``loose'' operators and their corresponding support functions.
29
30       If  a  schema  name is given then the operator family is created in the
31       specified schema. Otherwise it is created in the current  schema.   Two
32       operator  families  in  the  same schema can have the same name only if
33       they are for different index methods.
34
35       The user who defines an operator family becomes its  owner.  Presently,
36       the  creating  user  must  be  a  superuser.  (This restriction is made
37       because an erroneous operator family definition could confuse  or  even
38       crash the server.)
39
40       Refer to in the documentation for further information.
41

PARAMETERS

43       name   The  name  of the operator family to be created. The name can be
44              schema-qualified.
45
46       index_method
47              The name of the index method this operator family is for.
48

COMPATIBILITY

50       CREATE OPERATOR FAMILY is a PostgreSQL extension. There  is  no  CREATE
51       OPERATOR FAMILY statement in the SQL standard.
52

SEE ALSO

54       ALTER  OPERATOR FAMILY [alter_operator_family(7)], DROP OPERATOR FAMILY
55       [drop_operator_family(7)],   CREATE   OPERATOR   CLASS   [create_opera‐
56       tor_class(7)],  ALTER  OPERATOR  CLASS  [alter_operator_class(7)], DROP
57       OPERATOR CLASS [drop_operator_class(7)]
58
59
60
61SQL - Language Statements         2011-09-22         CREATE OPERATOR FAMILY(7)