{"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":"b724826fb0f8a1ddbcf1bb95354815dbcd4740324756bf15fd7b03dd76968d6e","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":"english-manuals:cc8a2c02ffd08ed9eb4ec05c830a20dd0d23d94663af76e5ac56f66e020511e6","summary":"The catalog pg_operator stores information about operators.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_operator","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_operator","SourceRevision":"english-manuals:cc8a2c02ffd08ed9eb4ec05c830a20dd0d23d94663af76e5ac56f66e020511e6","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},{"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},{"array_dimensions":0,"attnum":3,"description":"The OID of the namespace that contains this operator","description_zh":"","documented":true,"documented_name":"oprnamespace","hidden":false,"name":"oprnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26},{"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},{"array_dimensions":0,"attnum":5,"description":"b = infix operator (“both”), or l = prefix operator (“left”)","description_zh":"","documented":true,"documented_name":"oprkind","hidden":false,"name":"oprkind","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18},{"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},{"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},{"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},{"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},{"array_dimensions":0,"attnum":10,"description":"Type of the result (zero for a not-yet-defined “shell” operator)","description_zh":"","documented":true,"documented_name":"oprresult","hidden":false,"name":"oprresult","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26},{"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},{"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},{"array_dimensions":0,"attnum":13,"description":"Function that implements this operator (zero for a not-yet-defined “shell” operator)","description_zh":"","documented":true,"documented_name":"oprcode","hidden":false,"name":"oprcode","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24},{"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},{"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}],"description":"The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.","description_zh":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.36.4","file":"catalog-pg-operator.html","lang":"en","sha256":"e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_operator","Summary":"目录pg_operator存储关于操作符的信息。详见CREATE OPERATOR和第 36.14 节。","BodyHTML":"\u003cp\u003e目录pg_operator存储关于操作符的信息。详见CREATE OPERATOR和第 36.14 节。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"fc4fdca3d4da2a4aef9b8e52d40fbade5bd392c01806d7abaf3993863447886f","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"操作符的名称","name":"oprname","type":"name","zh_from":"doc"},{"description_zh":"操作符所属的名字空间的OID","name":"oprnamespace","type":"oid","zh_from":"doc"},{"description_zh":"操作符的拥有者","name":"oprowner","type":"oid","zh_from":"doc"},{"description_zh":"b = 中缀操作符（“两侧”），l = 前缀操作符（“左侧”）","name":"oprkind","type":"\"char\"","zh_from":"doc"},{"description_zh":"该操作符支持归并连接","name":"oprcanmerge","type":"boolean","zh_from":"doc"},{"description_zh":"该操作符支持哈希连接","name":"oprcanhash","type":"boolean","zh_from":"doc"},{"description_zh":"左操作数类型（对于前缀操作符用零）","name":"oprleft","type":"oid","zh_from":"doc"},{"description_zh":"右操作数类型","name":"oprright","type":"oid","zh_from":"doc"},{"description_zh":"结果类型（对于尚未定义的“shell”操作符为零）","name":"oprresult","type":"oid","zh_from":"doc"},{"description_zh":"该操作符的交换子（如没有则为零）","name":"oprcom","type":"oid","zh_from":"doc"},{"description_zh":"该操作符的求反器（如没有则为零）","name":"oprnegate","type":"oid","zh_from":"doc"},{"description_zh":"实现该操作符的函数（尚未定义的“shell”操作符则为零）","name":"oprcode","type":"regproc","zh_from":"doc"},{"description_zh":"该操作符的限制选择率估算函数（如果没有则为零）","name":"oprrest","type":"regproc","zh_from":"doc"},{"description_zh":"该操作符的连接选择率估算函数（如果没有则为零）","name":"oprjoin","type":"regproc","zh_from":"doc"}],"description_zh":"目录pg_operator存储关于操作符的信息。详见CREATE OPERATOR和第 36.14 节。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}