pg_range
The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- 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
Definition PG 18
The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| rngtypid | oid | Not null | OID of the range type |
| rngsubtype | oid | Not null | OID of the element type (subtype) of this range type |
| rngmultitypid | oid | Not null | OID of the multirange type for this range type |
| rngcollation | oid | Not null | OID of the collation used for range comparisons, or zero if none |
| rngsubopc | oid | Not null | OID of the subtype's operator class used for range comparisons |
| rngcanonical | regproc | Not null | OID of the function to convert a range value into canonical form, or zero if none |
| rngsubdiff | regproc | Not null | OID of the function to return the difference between two element values as double precision, or zero if none |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:81a53f371c3732537a4be5b1903a22bbbab516e7d5048eabe2a87bcad8d929b2
Text language: en · catalog-bilingual-repair:81a53f371c3732537a4be5b1903a22bbbab516e7d5048eabe2a87bcad8d929b2