{"Entry":{"collection":"catalog","key":"pg_opclass","name":"pg_opclass","aliases":[],"metadata":{"changed_in":["8.1","8.3","12"],"changes":[{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Input data type of the operator class","name":"opcintype","to":"Data type that the operator class indexes"},{"from":"Type of index data, or zero if same as opcintype","name":"opckeytype","to":"Type of data stored in index, or zero if same as opcintype"}],"from":"7.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Operator class owner","name":"opcowner","to":"Owner of the operator class"}],"from":"8.0","listing":[],"order":false,"removed":[],"status":"changed","to":"8.1","types":[{"from":"int4","name":"opcowner","to":"oid"}],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":["opcmethod","opcfamily"],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.2","listing":[],"order":false,"removed":["opcamid"],"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.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.2","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":"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":"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":9,"content_hash":"c4051d4579bea7d8566218658d1ffdcd9cfa52bfaf4d5a39e300dcc17756cebc","first_version":"7.4","imported_at":"2026-09-30T00:40:55.635883+08:00","kind":"catalog","last_version":"20","name":"pg_opclass","position":47,"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:5ff649e77c28125ad7fd33db6d2e72402f83dfbf95b1076b83b91c8eb6d6d562","summary":"The catalog pg_opclass defines index access method operator classes.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_opclass","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_opclass","SourceRevision":"english-manuals:5ff649e77c28125ad7fd33db6d2e72402f83dfbf95b1076b83b91c8eb6d6d562","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":"Index access method operator class is for","description_zh":"","documented":true,"documented_name":"opcmethod","hidden":false,"name":"opcmethod","not_null":true,"references":"pg_am.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"Name of this operator class","description_zh":"","documented":true,"documented_name":"opcname","hidden":false,"name":"opcname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":4,"description":"Namespace of this operator class","description_zh":"","documented":true,"documented_name":"opcnamespace","hidden":false,"name":"opcnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":5,"description":"Owner of the operator class","description_zh":"","documented":true,"documented_name":"opcowner","hidden":false,"name":"opcowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":6,"description":"Operator family containing the operator class","description_zh":"","documented":true,"documented_name":"opcfamily","hidden":false,"name":"opcfamily","not_null":true,"references":"pg_opfamily.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":7,"description":"Data type that the operator class indexes","description_zh":"","documented":true,"documented_name":"opcintype","hidden":false,"name":"opcintype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":8,"description":"True if this operator class is the default for opcintype","description_zh":"","documented":true,"documented_name":"opcdefault","hidden":false,"name":"opcdefault","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":9,"description":"Type of data stored in index, or zero if same as opcintype","description_zh":"","documented":true,"documented_name":"opckeytype","hidden":false,"name":"opckeytype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26}],"description":"The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular data type and a particular index access method. An operator class essentially specifies that a particular operator family is applicable to a particular indexable column data type. The set of operators from the family that are actually usable with the indexed column are whichever ones accept the column's data type as their left-hand input.\n\nOperator classes are described at length in Section 36.16.","description_zh":"","doc":{"anchor":"id-1.10.4.35.5","file":"catalog-pg-opclass.html","lang":"en","sha256":"6f131a502f81b813d447e746fc39ee28e5bdfb3ce8e8baea36a71ad0fde78c40","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","opcmethod","opcname","opcnamespace","opcowner","opcfamily","opcintype","opcdefault","opckeytype"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.35.5","file":"catalog-pg-opclass.html","lang":"en","sha256":"6f131a502f81b813d447e746fc39ee28e5bdfb3ce8e8baea36a71ad0fde78c40","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","opcmethod","opcname","opcnamespace","opcowner","opcfamily","opcintype","opcdefault","opckeytype"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_opclass","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_opclass","Summary":"目录pg_opclass定义索引访问方法的操作符类。每一个操作符类定义了一种特定数据类型和一种特定索引访问方法的索引列的语义。一个操作符类实际上指定了一个特定的操作符族可以用于一个特定可索引列数据类型。该族中可用于索引列的操作符能够接受该列的数据类型作为它们的左输入。\n\n操作符类详见第 36.16 节。","BodyHTML":"\u003cp\u003e目录pg_opclass定义索引访问方法的操作符类。每一个操作符类定义了一种特定数据类型和一种特定索引访问方法的索引列的语义。一个操作符类实际上指定了一个特定的操作符族可以用于一个特定可索引列数据类型。该族中可用于索引列的操作符能够接受该列的数据类型作为它们的左输入。\n\n操作符类详见第 36.16 节。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"331ee9e9421c1aa3e9760cf8c778071b6246f5119b6eb3111e14dc3ddb4c7e10","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"操作符类所属的索引访问方法","name":"opcmethod","type":"oid","zh_from":"doc"},{"description_zh":"操作符类的名称","name":"opcname","type":"name","zh_from":"doc"},{"description_zh":"操作符类所属的名字空间","name":"opcnamespace","type":"oid","zh_from":"doc"},{"description_zh":"操作符类的拥有者","name":"opcowner","type":"oid","zh_from":"doc"},{"description_zh":"包含此操作符类的操作符族","name":"opcfamily","type":"oid","zh_from":"doc"},{"description_zh":"操作符类索引的数据类型","name":"opcintype","type":"oid","zh_from":"doc"},{"description_zh":"如果此操作符类是 opcintype 的默认操作符类，则为真","name":"opcdefault","type":"boolean","zh_from":"doc"},{"description_zh":"存储在索引中的数据的类型，如果值为0表示与opcintype相同","name":"opckeytype","type":"oid","zh_from":"doc"}],"description_zh":"目录pg_opclass定义索引访问方法的操作符类。每一个操作符类定义了一种特定数据类型和一种特定索引访问方法的索引列的语义。一个操作符类实际上指定了一个特定的操作符族可以用于一个特定可索引列数据类型。该族中可用于索引列的操作符能够接受该列的数据类型作为它们的左输入。\n\n操作符类详见第 36.16 节。","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}