C operator precedence and order of evaluation NAME operator - C operator precedence and order of eva...define a new operator NAME CREATE_OPERATOR - define a new operator SYNOPSIS CREATE OPERATOR name ( {FUNCTION|PR...change the definition of an operator family NAME ALTER_OPERATOR_FAMILY - change the definition of an operator family SYNOPSIS...define a new operator family NAME CREATE_OPERATOR_FAMILY - define a new operator family SYNOPSIS CREATE OPERATO...define a new operator class NAME CREATE_OPERATOR_CLASS - define a new operator class SYNOPSIS CREATE OPERATOR C...C operator precedence and order of evaluation NAME operator - C operator precedence and order of eva...remove an operator NAME DROP_OPERATOR - remove an operator SYNOPSIS DROP OPERATOR [ IF EXISTS ] name ( { lef...remove an operator family NAME DROP_OPERATOR_FAMILY - remove an operator family SYNOPSIS DROP OPERATOR FAMIL...remove an operator class NAME DROP_OPERATOR_CLASS - remove an operator class SYNOPSIS DROP OPERATOR CLASS [...change the definition of an operator NAME ALTER_OPERATOR - change the definition of an operator SYNOPSIS ALTER OPERATOR name (...change the definition of an operator class NAME ALTER_OPERATOR_CLASS - change the definition of an operator class SYNOPSIS ALT......) ] | INDEX object_name | LARGE OBJECT large_object_oid | MATERIALIZED VIEW object_name | OPERATOR operator_name ( left_type , right_type ) | OPERATOR CLASS object_name USING in…...ame [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] | MATERIALIZED VIEW object_name | OPERATOR operator_name ( left_type , right_type ) | OPERATOR CLASS object_name USING in…...HERE. The same restrictions apply to index fields that are expressions. All functions and operators used in an index definition must be “immutable”, that is, their results must …...is a PostgreSQL extension. SEE ALSO DROP ACCESS METHOD ( DROP_ACCESS_METHOD (7)), CREATE OPERATOR CLASS ( CREATE_OPERATOR_CLASS (7)), CREATE OPERATOR FAMILY ( CREATE_OPERATOR_FA…...[, ... ] ] ) CREATE TYPE name AS RANGE ( SUBTYPE = subtype [ , SUBTYPE_OPCLASS = subtype_operator_class ] [ , COLLATION = collation ] [ , CANONICAL = canonical_function ] [ , SU…...TERSECT | EXCEPT } [ ALL | DISTINCT ] select ] [ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ] [ LIMIT { count | ALL } ] [ OFFSET star…...cess method. CASCADE Automatically drop objects that depend on the access method (such as operator classes, operator families, and indexes), and in turn all objects that depend …..._name [, ... ] ) index_parameters | EXCLUDE [ USING index_method ] ( exclude_element WITH operator [, ... ] ) index_parameters [ WHERE ( predicate ) ] | FOREIGN KEY ( column_nam…..._ONLY | SHAREABLE | READ_WRITE } ] [ , MINITCOND = minitial_condition ] [ , SORTOP = sort_operator ] [ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ] ) CREATE [ OR REPLACE ] AGGR…