历史版本。 PostgreSQL 9.2 已结束支持。 2017-11-09. 请参阅 当前版本手册.
45.32. pg_operator #
目录pg_operator存储关于操作符的信息。详见CREATE OPERATOR和第 35.12 节。
表 45.32. pg_operator 列
| Name | Type | References | Description |
|---|---|---|---|
oprname | name | Name of the operator | |
oprnamespace | oid | | The OID of the namespace that contains this operator |
oprowner | oid | | Owner of the operator |
oprkind | char | b = infix (“both”), l = prefix
(“left”), r = postfix (“right”)
| |
oprcanmerge | bool | This operator supports merge joins | |
oprcanhash | bool | This operator supports hash joins | |
oprleft | oid | | Type of the left operand |
oprright | oid | | Type of the right operand |
oprresult | oid | | Type of the result |
oprcom | oid | | Commutator of this operator, if any |
oprnegate | oid | | Negator of this operator, if any |
oprcode | regproc | | Function that implements this operator |
oprrest | regproc | | Restriction selectivity estimation function for this operator |
oprjoin | regproc | | Join selectivity estimation function for this operator |
未使用的列包含零。例如，前缀操作符的oprleft为零。