PostgreSQL 8.2.23 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 43. System Catalogs | Fast Forward | Next |
The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 33.12 for more information.
Table 43-25. pg_operator Columns
Name | Type | References | Description |
---|---|---|---|
oprname | name | Name of the operator | |
oprnamespace | oid | pg_namespace.oid | The OID of the namespace that contains this operator |
oprowner | oid | pg_authid.oid | Owner of the operator |
oprkind | char | b = infix ("both"), l = prefix ("left"), r = postfix ("right") | |
oprcanhash | bool | This operator supports hash joins | |
oprleft | oid | pg_type.oid | Type of the left operand |
oprright | oid | pg_type.oid | Type of the right operand |
oprresult | oid | pg_type.oid | Type of the result |
oprcom | oid | pg_operator.oid | Commutator of this operator, if any |
oprnegate | oid | pg_operator.oid | Negator of this operator, if any |
oprlsortop | oid | pg_operator.oid | If this operator supports merge joins, the operator that sorts the type of the left-hand operand (L<L) |
oprrsortop | oid | pg_operator.oid | If this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R) |
oprltcmpop | oid | pg_operator.oid | If this operator supports merge joins, the less-than operator that compares the left and right operand types (L<R) |
oprgtcmpop | oid | pg_operator.oid | If this operator supports merge joins, the greater-than operator that compares the left and right operand types (L>R) |
oprcode | regproc | pg_proc.oid | Function that implements this operator |
oprrest | regproc | pg_proc.oid | Restriction selectivity estimation function for this operator |
oprjoin | regproc | pg_proc.oid | Join selectivity estimation function for this operator |
Unused column contain zeroes. For example, oprleft is zero for a prefix operator.