{"Entry":{"collection":"catalog","key":"pg_amop","name":"pg_amop","aliases":[],"metadata":{"changed_in":["8.0","8.3","8.4","9.1","12"],"changes":[{"added":["amopsubtype"],"attributes":[],"description_changed":false,"descriptions":[],"from":"7.4","listing":[],"order":false,"removed":[],"status":"changed","to":"8.0","types":[],"unlisted":[]},{"added":["amopfamily","amoplefttype","amoprighttype","amopmethod"],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.2","listing":[],"order":false,"removed":["amopclaid","amopsubtype"],"status":"changed","to":"8.3","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.3","listing":[],"order":false,"removed":["amopreqcheck"],"status":"changed","to":"8.4","types":[],"unlisted":[]},{"added":["amoppurpose","amopsortfamily"],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.0","listing":[],"order":false,"removed":[],"status":"changed","to":"9.1","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The btree operator family this entry sorts according to, if an ordering operator; zero if a search operator","name":"amopsortfamily","to":"The B-tree operator family this entry sorts according to, if an ordering operator; zero if a search operator"}],"from":"9.3","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.4","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":false,"descriptions":[],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[],"unlisted":[]}],"column_count":9,"content_hash":"e8060cfdd59d84e703487a2a4990db5d3d4b07005f8ecb3145fa9eeb35e374d4","derived_content_hash":"338a7f8b229ef4e3f02b1f0a866e49a0845a7c663d6d9c5a3b21cb72fa9d69de","first_version":"7.4","imported_at":"2026-09-30T00:40:55.314335+08:00","kind":"catalog","last_version":"20","name":"pg_amop","position":3,"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:c93f23a64abda7e4d8f9e4837d752bb90ab408c464d9823afa7de40bade4ec14","summary":"The catalog pg_amop stores information about operators associated with access method operator families.","summary_zh":"目录 pg_amop 存储关于与访问方法操作符族相关的操作符信息。对于操作符族中的每个成员操作符，此目录中都有一行。一个成员可以是搜索操作符，也可以是排序操作符。一个操作符可以出现在多个族中，但在同一个族中既不能出现在多个搜索位置，也不能出现在多个排序位置（虽然不太可能，但允许一个操作符同时用于搜索和排序）。"}},"Definition":{"Collection":"catalog","Key":"pg_amop","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_amop","SourceRevision":"catalog-bilingual-repair:c93f23a64abda7e4d8f9e4837d752bb90ab408c464d9823afa7de40bade4ec14","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":"The operator family this entry is for","description_zh":"此项所属的操作符族","documented":true,"documented_name":"amopfamily","hidden":false,"name":"amopfamily","not_null":true,"references":"pg_opfamily.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Left-hand input data type of operator","description_zh":"操作符的左侧输入数据类型","documented":true,"documented_name":"amoplefttype","hidden":false,"name":"amoplefttype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Right-hand input data type of operator","description_zh":"操作符的右侧输入数据类型","documented":true,"documented_name":"amoprighttype","hidden":false,"name":"amoprighttype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Operator strategy number","description_zh":"操作符策略号","documented":true,"documented_name":"amopstrategy","hidden":false,"name":"amopstrategy","not_null":true,"references":"","type":"int2","type_modifier":-1,"type_oid":21,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Operator purpose, either s for search or o for ordering","description_zh":"操作符目的，s 表示搜索，o 表示排序","documented":true,"documented_name":"amoppurpose","hidden":false,"name":"amoppurpose","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"OID of the operator","description_zh":"操作符的 OID","documented":true,"documented_name":"amopopr","hidden":false,"name":"amopopr","not_null":true,"references":"pg_operator.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Index access method operator family is for","description_zh":"此操作符族所属的索引访问方法","documented":true,"documented_name":"amopmethod","hidden":false,"name":"amopmethod","not_null":true,"references":"pg_am.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"The B-tree operator family this entry sorts according to, if an ordering operator; zero if a search operator","description_zh":"如果是排序操作符，则此项按这个 B-树操作符族排序；如果是搜索操作符，则为零","documented":true,"documented_name":"amopsortfamily","hidden":false,"name":"amopsortfamily","not_null":true,"references":"pg_opfamily.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"}],"description":"The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that is a member of an operator family. A family member can be either a search operator or an ordering operator. An operator can appear in more than one family, but cannot appear in more than one search position nor more than one ordering position within a family. (It is allowed, though unlikely, for an operator to be used for both search and ordering purposes.)","description_zh":"目录 pg_amop 存储关于与访问方法操作符族相关的操作符信息。对于操作符族中的每个成员操作符，此目录中都有一行。一个成员可以是搜索操作符，也可以是排序操作符。一个操作符可以出现在多个族中，但在同一个族中既不能出现在多个搜索位置，也不能出现在多个排序位置（虽然不太可能，但允许一个操作符同时用于搜索和排序）。","description_zh_html":"\u003cp\u003e目录 pg_amop 存储关于与访问方法操作符族相关的操作符信息。对于操作符族中的每个成员操作符，此目录中都有一行。一个成员可以是搜索操作符，也可以是排序操作符。一个操作符可以出现在多个族中，但在同一个族中既不能出现在多个搜索位置，也不能出现在多个排序位置（虽然不太可能，但允许一个操作符同时用于搜索和排序）。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.6.4","file":"catalog-pg-amop.html","lang":"en","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","amopfamily","amoplefttype","amoprighttype","amopstrategy","amoppurpose","amopopr","amopmethod","amopsortfamily"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-amop.html","sha256":"41524bad7556efc3fe05afc3311dcff3860d4501271c9fe7f4f069777817642e","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:118aa05875ef279d076cc032649b182eb26721ae5b5e6ae70f97c6dfba5c20ac","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.6.4","file":"catalog-pg-amop.html","lang":"en","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-amop.html","sha256":"41524bad7556efc3fe05afc3311dcff3860d4501271c9fe7f4f069777817642e","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:118aa05875ef279d076cc032649b182eb26721ae5b5e6ae70f97c6dfba5c20ac","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","amopfamily","amoplefttype","amoprighttype","amopstrategy","amoppurpose","amopopr","amopmethod","amopsortfamily"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_amop","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_amop","Summary":"The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that is a member of an operator family. A family member can be either a search operator or an ordering operator. An operator can appear in more than one family, but cannot appear in more than one search position nor more than one ordering position within a family. (It is allowed, though unlikely, for an operator to be used for both search and ordering purposes.)","BodyHTML":"\u003cp\u003eThe catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that is a member of an operator family. A family member can be either a search operator or an ordering operator. An operator can appear in more than one family, but cannot appear in more than one search position nor more than one ordering position within a family. (It is allowed, though unlikely, for an operator to be used for both search and ordering purposes.)\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:c93f23a64abda7e4d8f9e4837d752bb90ab408c464d9823afa7de40bade4ec14","ContentHash":"1ebe20d795c49895002a8a36e82d12a4e89df85a06891c5d9b6b507a7f030a20","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":"The operator family this entry is for","description_zh":"此项所属的操作符族","documented":true,"documented_name":"amopfamily","hidden":false,"name":"amopfamily","not_null":true,"references":"pg_opfamily.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Left-hand input data type of operator","description_zh":"操作符的左侧输入数据类型","documented":true,"documented_name":"amoplefttype","hidden":false,"name":"amoplefttype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Right-hand input data type of operator","description_zh":"操作符的右侧输入数据类型","documented":true,"documented_name":"amoprighttype","hidden":false,"name":"amoprighttype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Operator strategy number","description_zh":"操作符策略号","documented":true,"documented_name":"amopstrategy","hidden":false,"name":"amopstrategy","not_null":true,"references":"","type":"int2","type_modifier":-1,"type_oid":21,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Operator purpose, either s for search or o for ordering","description_zh":"操作符目的，s 表示搜索，o 表示排序","documented":true,"documented_name":"amoppurpose","hidden":false,"name":"amoppurpose","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"OID of the operator","description_zh":"操作符的 OID","documented":true,"documented_name":"amopopr","hidden":false,"name":"amopopr","not_null":true,"references":"pg_operator.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Index access method operator family is for","description_zh":"此操作符族所属的索引访问方法","documented":true,"documented_name":"amopmethod","hidden":false,"name":"amopmethod","not_null":true,"references":"pg_am.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"The B-tree operator family this entry sorts according to, if an ordering operator; zero if a search operator","description_zh":"如果是排序操作符，则此项按这个 B-树操作符族排序；如果是搜索操作符，则为零","documented":true,"documented_name":"amopsortfamily","hidden":false,"name":"amopsortfamily","not_null":true,"references":"pg_opfamily.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"}],"description":"The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that is a member of an operator family. A family member can be either a search operator or an ordering operator. An operator can appear in more than one family, but cannot appear in more than one search position nor more than one ordering position within a family. (It is allowed, though unlikely, for an operator to be used for both search and ordering purposes.)"}},"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}