{"Entry":{"collection":"catalog","key":"pg_operator","name":"pg_operator","aliases":[],"metadata":{"changed_in":["8.1","8.3","12"],"changes":[{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"7.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.0","listing":[],"order":false,"removed":[],"status":"changed","to":"8.1","types":[{"from":"int4","name":"oprowner","to":"oid"}],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":["oprcanmerge"],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.2","listing":[],"order":false,"removed":["oprlsortop","oprrsortop","oprltcmpop","oprgtcmpop"],"status":"changed","to":"8.3","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.5","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.6","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"b = infix (\"both\"), l = prefix (\"left\"), r = postfix (\"right\")","name":"oprkind","to":"b = infix (“both”), l = prefix (“left”), r = postfix (“right”)"}],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"10","listing":[],"order":false,"removed":[],"status":"reworded","to":"11","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":true,"descriptions":[],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Function that implements this operator","name":"oprcode","to":"Function that implements this operator (zero for a not-yet-defined “shell” operator)"},{"from":"Commutator of this operator, if any","name":"oprcom","to":"Commutator of this operator (zero if none)"},{"from":"Join selectivity estimation function for this operator","name":"oprjoin","to":"Join selectivity estimation function for this operator (zero if none)"},{"from":"b = infix (“both”), l = prefix (“left”), r = postfix (“right”)","name":"oprkind","to":"b = infix operator (“both”), or l = prefix operator (“left”)"},{"from":"Type of the left operand","name":"oprleft","to":"Type of the left operand (zero for a prefix operator)"},{"from":"Negator of this operator, if any","name":"oprnegate","to":"Negator of this operator (zero if none)"},{"from":"Restriction selectivity estimation function for this operator","name":"oprrest","to":"Restriction selectivity estimation function for this operator (zero if none)"},{"from":"Type of the result","name":"oprresult","to":"Type of the result (zero for a not-yet-defined “shell” operator)"}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]}],"column_count":15,"content_hash":"0bff5c4c75ed5863b9aa480f4caf76e1227347759395966309c0c25947cf111d","derived_content_hash":"464428684a75ab6f519191d29ae7c1a7acd90c7bcdaa99d651cf056fcfa2b726","first_version":"7.4","imported_at":"2026-09-30T00:40:55.647163+08:00","kind":"catalog","last_version":"20","name":"pg_operator","position":48,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:845601b6eef300a84d1a2f3985b826fe0f4b4ebefd17d44f389eb41f54d27177","summary":"The catalog pg_operator stores information about operators.","summary_zh":"目录 pg_operator 存储关于操作符的信息。详见 CREATE OPERATOR 和第 36.14 节。"}},"Definition":{"Collection":"catalog","Key":"pg_operator","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_operator","SourceRevision":"catalog-bilingual-repair:845601b6eef300a84d1a2f3985b826fe0f4b4ebefd17d44f389eb41f54d27177","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of the operator","description_zh":"操作符的名称","documented":true,"documented_name":"oprname","hidden":false,"name":"oprname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The OID of the namespace that contains this operator","description_zh":"操作符所属的名字空间的 OID","documented":true,"documented_name":"oprnamespace","hidden":false,"name":"oprnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Owner of the operator","description_zh":"操作符的拥有者","documented":true,"documented_name":"oprowner","hidden":false,"name":"oprowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"b = infix operator (“both”), or l = prefix operator (“left”)","description_zh":"b = 中缀操作符（“两侧”），l = 前缀操作符（“左侧”）","documented":true,"documented_name":"oprkind","hidden":false,"name":"oprkind","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"This operator supports merge joins","description_zh":"该操作符支持归并连接","documented":true,"documented_name":"oprcanmerge","hidden":false,"name":"oprcanmerge","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"This operator supports hash joins","description_zh":"该操作符支持哈希连接","documented":true,"documented_name":"oprcanhash","hidden":false,"name":"oprcanhash","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Type of the left operand (zero for a prefix operator)","description_zh":"左操作数类型（对于前缀操作符用零）","documented":true,"documented_name":"oprleft","hidden":false,"name":"oprleft","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Type of the right operand","description_zh":"右操作数类型","documented":true,"documented_name":"oprright","hidden":false,"name":"oprright","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Type of the result (zero for a not-yet-defined “shell” operator)","description_zh":"结果类型（对于尚未定义的“shell”操作符为零）","documented":true,"documented_name":"oprresult","hidden":false,"name":"oprresult","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"Commutator of this operator (zero if none)","description_zh":"该操作符的交换子（如没有则为零）","documented":true,"documented_name":"oprcom","hidden":false,"name":"oprcom","not_null":true,"references":"pg_operator.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Negator of this operator (zero if none)","description_zh":"该操作符的求反器（如没有则为零）","documented":true,"documented_name":"oprnegate","hidden":false,"name":"oprnegate","not_null":true,"references":"pg_operator.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":13,"description":"Function that implements this operator (zero for a not-yet-defined “shell” operator)","description_zh":"实现该操作符的函数（尚未定义的“shell”操作符则为零）","documented":true,"documented_name":"oprcode","hidden":false,"name":"oprcode","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":14,"description":"Restriction selectivity estimation function for this operator (zero if none)","description_zh":"该操作符的限制选择率估算函数（如果没有则为零）","documented":true,"documented_name":"oprrest","hidden":false,"name":"oprrest","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":15,"description":"Join selectivity estimation function for this operator (zero if none)","description_zh":"该操作符的连接选择率估算函数（如果没有则为零）","documented":true,"documented_name":"oprjoin","hidden":false,"name":"oprjoin","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"}],"description":"The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.","description_zh":"目录 pg_operator 存储关于操作符的信息。详见 CREATE OPERATOR 和第 36.14 节。","description_zh_html":"\u003cp\u003e目录 pg_operator 存储关于操作符的信息。详见 CREATE OPERATOR 和第 36.14 节。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.36.4","file":"catalog-pg-operator.html","lang":"en","sha256":"e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","oprname","oprnamespace","oprowner","oprkind","oprcanmerge","oprcanhash","oprleft","oprright","oprresult","oprcom","oprnegate","oprcode","oprrest","oprjoin"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-operator.html","sha256":"866547c7d8dd1d830de6c28cee33e2e3adb45288d1d47be58b03fbfb346e9d08","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:cc8a2c02ffd08ed9eb4ec05c830a20dd0d23d94663af76e5ac56f66e020511e6","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.36.4","file":"catalog-pg-operator.html","lang":"en","sha256":"e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-operator.html","sha256":"866547c7d8dd1d830de6c28cee33e2e3adb45288d1d47be58b03fbfb346e9d08","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:cc8a2c02ffd08ed9eb4ec05c830a20dd0d23d94663af76e5ac56f66e020511e6","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","oprname","oprnamespace","oprowner","oprkind","oprcanmerge","oprcanhash","oprleft","oprright","oprresult","oprcom","oprnegate","oprcode","oprrest","oprjoin"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_operator","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_operator","Summary":"The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.","BodyHTML":"\u003cp\u003eThe catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:845601b6eef300a84d1a2f3985b826fe0f4b4ebefd17d44f389eb41f54d27177","ContentHash":"346a6217c2fe922a1ab224b9794f804f293f9479c1ed53ffcd1f8e391d38aaaa","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of the operator","description_zh":"操作符的名称","documented":true,"documented_name":"oprname","hidden":false,"name":"oprname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The OID of the namespace that contains this operator","description_zh":"操作符所属的名字空间的 OID","documented":true,"documented_name":"oprnamespace","hidden":false,"name":"oprnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Owner of the operator","description_zh":"操作符的拥有者","documented":true,"documented_name":"oprowner","hidden":false,"name":"oprowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"b = infix operator (“both”), or l = prefix operator (“left”)","description_zh":"b = 中缀操作符（“两侧”），l = 前缀操作符（“左侧”）","documented":true,"documented_name":"oprkind","hidden":false,"name":"oprkind","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"This operator supports merge joins","description_zh":"该操作符支持归并连接","documented":true,"documented_name":"oprcanmerge","hidden":false,"name":"oprcanmerge","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"This operator supports hash joins","description_zh":"该操作符支持哈希连接","documented":true,"documented_name":"oprcanhash","hidden":false,"name":"oprcanhash","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Type of the left operand (zero for a prefix operator)","description_zh":"左操作数类型（对于前缀操作符用零）","documented":true,"documented_name":"oprleft","hidden":false,"name":"oprleft","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Type of the right operand","description_zh":"右操作数类型","documented":true,"documented_name":"oprright","hidden":false,"name":"oprright","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Type of the result (zero for a not-yet-defined “shell” operator)","description_zh":"结果类型（对于尚未定义的“shell”操作符为零）","documented":true,"documented_name":"oprresult","hidden":false,"name":"oprresult","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"Commutator of this operator (zero if none)","description_zh":"该操作符的交换子（如没有则为零）","documented":true,"documented_name":"oprcom","hidden":false,"name":"oprcom","not_null":true,"references":"pg_operator.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Negator of this operator (zero if none)","description_zh":"该操作符的求反器（如没有则为零）","documented":true,"documented_name":"oprnegate","hidden":false,"name":"oprnegate","not_null":true,"references":"pg_operator.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":13,"description":"Function that implements this operator (zero for a not-yet-defined “shell” operator)","description_zh":"实现该操作符的函数（尚未定义的“shell”操作符则为零）","documented":true,"documented_name":"oprcode","hidden":false,"name":"oprcode","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":14,"description":"Restriction selectivity estimation function for this operator (zero if none)","description_zh":"该操作符的限制选择率估算函数（如果没有则为零）","documented":true,"documented_name":"oprrest","hidden":false,"name":"oprrest","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":15,"description":"Join selectivity estimation function for this operator (zero if none)","description_zh":"该操作符的连接选择率估算函数（如果没有则为零）","documented":true,"documented_name":"oprjoin","hidden":false,"name":"oprjoin","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"}],"description":"The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}