PG_OPERATOR
PG_OPERATOR records information about operators.
Name | Type | Reference | Description |
|---|---|---|---|
oid | oid | - | Row identifier (hidden attribute, which must be specified) |
oprname | name | - | Name of an operator |
oprnamespace | oid | oid in PG_NAMESPACE | OID of the namespace that contains the operator. |
oprowner | oid | oid in PG_AUTHID | Owner of the operator. |
oprkind | "char" | - |
|
oprcanmerge | boolean | - | Whether the operator supports merge joins
|
oprcanhash | boolean | - | Whether the operator supports hash joins
|
oprleft | oid | oid in PG_TYPE | Type of the left operand. |
oprright | oid | oid in PG_TYPE | Type of the right operand. |
oprresult | oid | oid in PG_TYPE | Type of the result. |
oprcom | oid | oid in PG_OPERATOR | If it exists, the value is the exchange character of this operator. If it does not exist, the value is 0. |
oprnegate | oid | oid in PG_OPERATOR | If it exists, the value is the invertor of this operator. If it does not exist, the value is 0. |
oprcode | regproc | proname in PG_PROC | Function that implements the operator. |
oprrest | regproc | proname in PG_PROC | Restriction selectivity estimation function for the operator. |
oprjoin | regproc | proname in PG_PROC | Join selectivity estimation function for the operator. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
