{"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":"0bac3ee69c465803c58e9d1834c1ef368a77b95f29cad7ea9e19fe8271314eae","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":"english-manuals:118aa05875ef279d076cc032649b182eb26721ae5b5e6ae70f97c6dfba5c20ac","summary":"The catalog pg_amop stores information about operators associated with access method operator families.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_amop","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_amop","SourceRevision":"english-manuals:118aa05875ef279d076cc032649b182eb26721ae5b5e6ae70f97c6dfba5c20ac","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":"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},{"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},{"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},{"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},{"array_dimensions":0,"attnum":6,"description":"Operator purpose, either s for search or o for ordering","description_zh":"","documented":true,"documented_name":"amoppurpose","hidden":false,"name":"amoppurpose","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18},{"array_dimensions":0,"attnum":7,"description":"OID of the operator","description_zh":"","documented":true,"documented_name":"amopopr","hidden":false,"name":"amopopr","not_null":true,"references":"pg_operator.oid","type":"oid","type_modifier":-1,"type_oid":26},{"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},{"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":"","documented":true,"documented_name":"amopsortfamily","hidden":false,"name":"amopsortfamily","not_null":true,"references":"pg_opfamily.oid","type":"oid","type_modifier":-1,"type_oid":26}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.6.4","file":"catalog-pg-amop.html","lang":"en","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_amop","Summary":"目录pg_amop存储关于与访问方法操作符族相关的操作符信息。对于操作符族中的每个成员操作符，此目录中都有一行。一个成员可以是搜索操作符，也可以是排序操作符。一个操作符可以出现在多个族中，但在同一个族中既不能出现在多个搜索位置，也不能出现在多个排序位置（虽然不太可能，但允许一个操作符同时用于搜索和排序）。","BodyHTML":"\u003cp\u003e目录pg_amop存储关于与访问方法操作符族相关的操作符信息。对于操作符族中的每个成员操作符，此目录中都有一行。一个成员可以是搜索操作符，也可以是排序操作符。一个操作符可以出现在多个族中，但在同一个族中既不能出现在多个搜索位置，也不能出现在多个排序位置（虽然不太可能，但允许一个操作符同时用于搜索和排序）。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"9729157253f77f8263143f4dbeb0cab43aa227e4af1ec611692cbd183d0e2474","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"此项所属的操作符族","name":"amopfamily","type":"oid","zh_from":"doc"},{"description_zh":"操作符的左侧输入数据类型","name":"amoplefttype","type":"oid","zh_from":"doc"},{"description_zh":"操作符的右侧输入数据类型","name":"amoprighttype","type":"oid","zh_from":"doc"},{"description_zh":"操作符策略号","name":"amopstrategy","type":"smallint","zh_from":"doc"},{"description_zh":"操作符目的，s表示搜索，o表示排序","name":"amoppurpose","type":"\"char\"","zh_from":"doc"},{"description_zh":"操作符的OID","name":"amopopr","type":"oid","zh_from":"doc"},{"description_zh":"此操作符族所属的索引访问方法","name":"amopmethod","type":"oid","zh_from":"doc"},{"description_zh":"如果是排序操作符，则此项按这个 B-树操作符族排序；如果是搜索操作符，则为零","name":"amopsortfamily","type":"oid","zh_from":"doc"}],"description_zh":"目录pg_amop存储关于与访问方法操作符族相关的操作符信息。对于操作符族中的每个成员操作符，此目录中都有一行。一个成员可以是搜索操作符，也可以是排序操作符。一个操作符可以出现在多个族中，但在同一个族中既不能出现在多个搜索位置，也不能出现在多个排序位置（虽然不太可能，但允许一个操作符同时用于搜索和排序）。","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}