{"Entry":{"collection":"catalog","key":"pg_range","name":"pg_range","aliases":[],"metadata":{"changed_in":["14","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.1","order":false,"removed":[],"status":"added","to":"9.2","types":[]},{"added":["rngmultitypid"],"attributes":[],"description_changed":false,"descriptions":[{"from":"OID of the function to convert a range value into canonical form, or 0 if none","name":"rngcanonical","to":"OID of the function to convert a range value into canonical form, or zero if none"},{"from":"OID of the collation used for range comparisons, or 0 if none","name":"rngcollation","to":"OID of the collation used for range comparisons, or zero if none"},{"from":"OID of the function to return the difference between two element values as double precision, or 0 if none","name":"rngsubdiff","to":"OID of the function to return the difference between two element values as double precision, or zero if none"}],"from":"13","listing":[],"order":false,"removed":[],"status":"changed","to":"14","types":[],"unlisted":[]},{"added":["rngconstruct2","rngconstruct3","rngmltconstruct0","rngmltconstruct1","rngmltconstruct2"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":12,"content_hash":"2de3bcbee174b6bf7b43d04c11aa861e0343fff53214be61f260ce5b1a5a2e76","derived_content_hash":"0cf5aaf065e8598144ffe7e875e59f5b529a1da684a9a4f871bcb01012a68ff1","first_version":"9.2","imported_at":"2026-09-30T00:40:55.741288+08:00","kind":"catalog","last_version":"20","name":"pg_range","position":63,"present_in":["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:81a53f371c3732537a4be5b1903a22bbbab516e7d5048eabe2a87bcad8d929b2","summary":"The catalog pg_range stores information about range types.","summary_zh":"目录 pg_range 存储关于范围类型的信息。它是类型在 pg_type 中的项的补充。"}},"Definition":{"Collection":"catalog","Key":"pg_range","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_range","SourceRevision":"catalog-bilingual-repair:81a53f371c3732537a4be5b1903a22bbbab516e7d5048eabe2a87bcad8d929b2","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the range type","description_zh":"范围类型的 OID","documented":true,"documented_name":"rngtypid","hidden":false,"name":"rngtypid","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"OID of the element type (subtype) of this range type","description_zh":"该范围类型的元素类型（子类型）的 OID","documented":true,"documented_name":"rngsubtype","hidden":false,"name":"rngsubtype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"OID of the multirange type for this range type","description_zh":"这个范围类型的多范围类型的 OID。","documented":true,"documented_name":"rngmultitypid","hidden":false,"name":"rngmultitypid","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":"OID of the collation used for range comparisons, or zero if none","description_zh":"用于范围比较的排序规则的 OID，如果没有则为零","documented":true,"documented_name":"rngcollation","hidden":false,"name":"rngcollation","not_null":true,"references":"pg_collation.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"OID of the subtype's operator class used for range comparisons","description_zh":"用于范围比较的子类型的操作符类的 OID","documented":true,"documented_name":"rngsubopc","hidden":false,"name":"rngsubopc","not_null":true,"references":"pg_opclass.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"OID of the function to convert a range value into canonical form, or zero if none","description_zh":"将一个范围值转换为规范形式的函数的 OID，如果没有则为零","documented":true,"documented_name":"rngcanonical","hidden":false,"name":"rngcanonical","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"OID of the function to return the difference between two element values as double precision, or zero if none","description_zh":"返回两个元素值之差并以 double precision 表示的函数的 OID；如果没有则为零","documented":true,"documented_name":"rngsubdiff","hidden":false,"name":"rngsubdiff","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"}],"description":"The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type.","description_zh":"目录 pg_range 存储关于范围类型的信息。它是类型在 pg_type 中的项的补充。","description_zh_html":"\u003cp\u003e目录 pg_range 存储关于范围类型的信息。它是类型在 pg_type 中的项的补充。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.45.4","file":"catalog-pg-range.html","lang":"en","sha256":"489d6953162120ab4494876dea88b82aab50d3ea47e7c3a88bb484f3553678e8","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["rngtypid","rngsubtype","rngmultitypid","rngcollation","rngsubopc","rngcanonical","rngsubdiff"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-range.html","sha256":"af30423d71f41b1daefd6216f14dcc0aa6f1e817536c7fd78f6528634e26561a","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:0af05c551400513b4770b88698a8ff0bd335ded951f2e485bf2425e64f56b9d2","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.45.4","file":"catalog-pg-range.html","lang":"en","sha256":"489d6953162120ab4494876dea88b82aab50d3ea47e7c3a88bb484f3553678e8","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-range.html","sha256":"af30423d71f41b1daefd6216f14dcc0aa6f1e817536c7fd78f6528634e26561a","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:0af05c551400513b4770b88698a8ff0bd335ded951f2e485bf2425e64f56b9d2","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["rngtypid","rngsubtype","rngmultitypid","rngcollation","rngsubopc","rngcanonical","rngsubdiff"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_range","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_range","Summary":"The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type.","BodyHTML":"\u003cp\u003eThe catalog pg_range stores information about range types. This is in addition to the types\u0026#39; entries in pg_type.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:81a53f371c3732537a4be5b1903a22bbbab516e7d5048eabe2a87bcad8d929b2","ContentHash":"cdac6004e5a6617ab4254ccb26ca4760bee7de2cd267d3c037d9016a831131d6","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the range type","description_zh":"范围类型的 OID","documented":true,"documented_name":"rngtypid","hidden":false,"name":"rngtypid","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"OID of the element type (subtype) of this range type","description_zh":"该范围类型的元素类型（子类型）的 OID","documented":true,"documented_name":"rngsubtype","hidden":false,"name":"rngsubtype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"OID of the multirange type for this range type","description_zh":"这个范围类型的多范围类型的 OID。","documented":true,"documented_name":"rngmultitypid","hidden":false,"name":"rngmultitypid","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":"OID of the collation used for range comparisons, or zero if none","description_zh":"用于范围比较的排序规则的 OID，如果没有则为零","documented":true,"documented_name":"rngcollation","hidden":false,"name":"rngcollation","not_null":true,"references":"pg_collation.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"OID of the subtype's operator class used for range comparisons","description_zh":"用于范围比较的子类型的操作符类的 OID","documented":true,"documented_name":"rngsubopc","hidden":false,"name":"rngsubopc","not_null":true,"references":"pg_opclass.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"OID of the function to convert a range value into canonical form, or zero if none","description_zh":"将一个范围值转换为规范形式的函数的 OID，如果没有则为零","documented":true,"documented_name":"rngcanonical","hidden":false,"name":"rngcanonical","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"OID of the function to return the difference between two element values as double precision, or zero if none","description_zh":"返回两个元素值之差并以 double precision 表示的函数的 OID；如果没有则为零","documented":true,"documented_name":"rngsubdiff","hidden":false,"name":"rngsubdiff","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24,"zh_from":"same-version-manual"}],"description":"The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}