{"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":"5d656141cc03c5f34a4b3c2d9282bd93f247c01621256cf2f9c39a7324313f0d","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":"english-manuals:0af05c551400513b4770b88698a8ff0bd335ded951f2e485bf2425e64f56b9d2","summary":"The catalog pg_range stores information about range types.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_range","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_range","SourceRevision":"english-manuals:0af05c551400513b4770b88698a8ff0bd335ded951f2e485bf2425e64f56b9d2","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the range type","description_zh":"","documented":true,"documented_name":"rngtypid","hidden":false,"name":"rngtypid","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"OID of the element type (subtype) of this range type","description_zh":"","documented":true,"documented_name":"rngsubtype","hidden":false,"name":"rngsubtype","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"OID of the multirange type for this range type","description_zh":"","documented":true,"documented_name":"rngmultitypid","hidden":false,"name":"rngmultitypid","not_null":true,"references":"pg_type.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":4,"description":"OID of the collation used for range comparisons, or zero if none","description_zh":"","documented":true,"documented_name":"rngcollation","hidden":false,"name":"rngcollation","not_null":true,"references":"pg_collation.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":5,"description":"OID of the subtype's operator class used for range comparisons","description_zh":"","documented":true,"documented_name":"rngsubopc","hidden":false,"name":"rngsubopc","not_null":true,"references":"pg_opclass.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":6,"description":"OID of the function to convert a range value into canonical form, or zero if none","description_zh":"","documented":true,"documented_name":"rngcanonical","hidden":false,"name":"rngcanonical","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24},{"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":"","documented":true,"documented_name":"rngsubdiff","hidden":false,"name":"rngsubdiff","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24}],"description":"The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type.","description_zh":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.45.4","file":"catalog-pg-range.html","lang":"en","sha256":"489d6953162120ab4494876dea88b82aab50d3ea47e7c3a88bb484f3553678e8","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_range","Summary":"目录pg_range存储关于范围类型的信息。它是类型在pg_type中的项的补充。","BodyHTML":"\u003cp\u003e目录pg_range存储关于范围类型的信息。它是类型在pg_type中的项的补充。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"853d5de3e6f149ae0b8689cf6f03a530590692b67a81caff23d60b3e74d8e2c4","Payload":{"columns":[{"description_zh":"范围类型的OID","name":"rngtypid","type":"oid","zh_from":"doc"},{"description_zh":"该范围类型的元素类型（子类型）的OID","name":"rngsubtype","type":"oid","zh_from":"doc"},{"description_zh":"这个范围类型的多范围类型的OID。","name":"rngmultitypid","type":"oid","zh_from":"doc"},{"description_zh":"用于范围比较的排序规则的OID，如果没有则为零","name":"rngcollation","type":"oid","zh_from":"doc"},{"description_zh":"用于范围比较的子类型的操作符类的OID","name":"rngsubopc","type":"oid","zh_from":"doc"},{"description_zh":"将一个范围值转换为规范形式的函数的OID，如果没有则为零","name":"rngcanonical","type":"regproc","zh_from":"doc"},{"description_zh":"返回两个元素值之差并以 double precision 表示的函数的 OID；如果没有则为零","name":"rngsubdiff","type":"regproc","zh_from":"doc"}],"description_zh":"目录pg_range存储关于范围类型的信息。它是类型在pg_type中的项的补充。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}