{"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":"a7b17c902cd0e5a441ed5db6df7d0180f638f151db4f3ce2065eff2fdb4d6c72","derived_content_hash":"59fb163e70d159c291dd02541af5331e18fce8f84603e6d3dccfd0804c92635b","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":"catalog-bilingual-repair:6e732ccf7ba6fa51f53f69d8286d99c15aa96c3055afd6a09455194fc0b66bcd","summary":"The catalog pg_opclass defines index access method operator classes.","summary_zh":"目录 pg_opclass 定义索引访问方法的操作符类。每一个操作符类定义了一种特定数据类型和一种特定索引访问方法的索引列的语义。一个操作符类实际上指定了一个特定的操作符族可以用于一个特定可索引列数据类型。该族中实际可用于索引列的操作符，正是那些接受该列的数据类型作为左输入的操作符。"}},"Definition":{"Collection":"catalog","Key":"pg_opclass","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_opclass","SourceRevision":"catalog-bilingual-repair:6e732ccf7ba6fa51f53f69d8286d99c15aa96c3055afd6a09455194fc0b66bcd","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":"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"True if this operator class is the default for opcintype","description_zh":"如果此操作符类是 opcintype 的默认操作符类，则为真","documented":true,"documented_name":"opcdefault","hidden":false,"name":"opcdefault","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Type of data stored in index, or zero if same as opcintype","description_zh":"存储在索引中的数据的类型，如果值为 0 表示与 opcintype 相同","documented":true,"documented_name":"opckeytype","hidden":false,"name":"opckeytype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"}],"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":"目录 pg_opclass 定义索引访问方法的操作符类。每一个操作符类定义了一种特定数据类型和一种特定索引访问方法的索引列的语义。一个操作符类实际上指定了一个特定的操作符族可以用于一个特定可索引列数据类型。该族中可用于索引列的操作符能够接受该列的数据类型作为它们的左输入。\n\n操作符类详见第 36.16 节。","description_zh_html":"\u003cp\u003e目录 pg_opclass 定义索引访问方法的操作符类。每一个操作符类定义了一种特定数据类型和一种特定索引访问方法的索引列的语义。一个操作符类实际上指定了一个特定的操作符族可以用于一个特定可索引列数据类型。该族中可用于索引列的操作符能够接受该列的数据类型作为它们的左输入。\u003c/p\u003e\n\u003cp\u003e操作符类详见第 36.16 节。\u003c/p\u003e","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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-opclass.html","sha256":"cccd05134bc1bc1e964a2d746851b7423da1c1593c4998569da5a5a3b345d7de","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:5ff649e77c28125ad7fd33db6d2e72402f83dfbf95b1076b83b91c8eb6d6d562","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.35.5","file":"catalog-pg-opclass.html","lang":"en","sha256":"6f131a502f81b813d447e746fc39ee28e5bdfb3ce8e8baea36a71ad0fde78c40","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-opclass.html","sha256":"cccd05134bc1bc1e964a2d746851b7423da1c1593c4998569da5a5a3b345d7de","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:5ff649e77c28125ad7fd33db6d2e72402f83dfbf95b1076b83b91c8eb6d6d562","version":"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":"center","Version":"18","Locale":"en","Title":"pg_opclass","Summary":"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.","BodyHTML":"\u003cp\u003eThe 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\u0026#39;s data type as their left-hand input.\n\nOperator classes are described at length in Section 36.16.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:6e732ccf7ba6fa51f53f69d8286d99c15aa96c3055afd6a09455194fc0b66bcd","ContentHash":"ce5e16bc13e0e8dc024f079b2650f449a7737c4e7a3f566a042531849dd2b6c2","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":"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"True if this operator class is the default for opcintype","description_zh":"如果此操作符类是 opcintype 的默认操作符类，则为真","documented":true,"documented_name":"opcdefault","hidden":false,"name":"opcdefault","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Type of data stored in index, or zero if same as opcintype","description_zh":"存储在索引中的数据的类型，如果值为 0 表示与 opcintype 相同","documented":true,"documented_name":"opckeytype","hidden":false,"name":"opckeytype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"}],"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."}},"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}