ALTER OPERATOR FAMILY
The name of the index method this operator family is for.
The index method’s strategy number for an operator associated with the operator family.
The name (optionally schema-qualiﬁed) of an operator associated with the operator family.
clause, the operand data type(s) of the operator, or
to signify a left-
unaryor right-unary operator. Unlike the comparable syntax in
CREATE OPERATOR CLASS
operand data types must always be speciﬁed.
clause, the operand data type(s) the function is intended to support, if
different from the input data type(s) of the function. For B-tree comparison functions and hash
functions itis notnecessary to specify
since thefunction’s inputdata type(s) arealways
the correct ones to use. For B-tree sort support functions andall functions in GiST, SP-GiST and
GIN operator classes, itis necessary to specifythe operand data type(s) the functionis tobe used
clause, the operand data type(s) the function is intended to support must
The name (optionally schema-qualiﬁed) of an existing
operator family that describes the
sort ordering associated with an ordering operator.
FOR ORDER BY
is the default.
Theindexmethod’s supportprocedurenumber for afunctionassociated withthe operator family.
The name (optionally schema-qualiﬁed) of a functionthat is anindex method support procedure
for the operator family.
The parameter data type(s) of the function.
The new name of the operator family.
The new owner of the operator family.
The new schema for the operator family.
clauses can appear in any order.
Notice that the
syntax only speciﬁes the “slot” in the operator family, by strategy or support
number and input data type(s). The name of the operator or function occupying the slot is not men-