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 |
PG_NAMESPACE.oid |
OID of the namespace that contains the operator. |
oprowner |
oid |
PG_AUTHID.oid |
Owner of the operator. |
oprkind |
"char" |
- |
|
oprcanmerge |
Boolean |
- |
Specifies whether the operator supports merge joins.
|
oprcanhash |
Boolean |
- |
Specifies whether the 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 |
Exchange character of this operator if any; otherwise, 0. |
oprnegate |
oid |
PG_OPERATOR.oid |
Negator of this operator if any; otherwise, 0. |
oprcode |
regproc |
PG_PROC.proname |
Function that implements the operator |
oprrest |
regproc |
PG_PROC.proname |
Restriction selectivity estimation function for the operator. |
oprjoin |
regproc |
PG_PROC.proname |
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot