CREATE OPERATOR
CREATE OPERATOR
Name
CREATE OPERATOR -- define a new operatorSynopsis
CREATE OPERATOR name ( PROCEDURE = function_name [, LEFTARG = left_type ] [, RIGHTARG = right_type ] [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ] [, RESTRICT = res_proc ] [, JOIN = join_proc ] [, HASHES ] [, MERGES ] )
Description
CREATE OPERATOR
defines a new operator, name
. The user who defines an operator becomes its owner. If a schema name is given then the operator is created in the specified schema. Otherwise it is created in the current schema.
The operator name is a sequence of up to NAMEDATALEN
-1 (63 by default) characters from the following li