SYSTEM CATALOGS / SYSTEM CATALOGS
pg_range
Read PG 18 manual ↗The catalog pg_range stores information about range types.
- Kind
- System catalogs
- Columns in this snapshot
- 7
- Definition source
- English manual
Columns 7
| Column | Type | Description / reference |
|---|---|---|
rngtypid | oid | OID of the range type pg_type.oid |
rngsubtype | oid | OID of the element type (subtype) of this range type pg_type.oid |
rngmultitypid | oid | OID of the multirange type for this range type pg_type.oid |
rngcollation | oid | OID of the collation used for range comparisons, or zero if none pg_collation.oid |
rngsubopc | oid | OID of the subtype's operator class used for range comparisons pg_opclass.oid |
rngcanonical | regproc | OID of the function to convert a range value into canonical form, or zero if none pg_proc.oid |
rngsubdiff | regproc | OID of the function to return the difference between two element values as double precision, or zero if none pg_proc.oid |
Column history across versions
| Column | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
rngtypid | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
rngsubtype | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
rngcollation | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
rngsubopc | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
rngcanonical | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
rngsubdiff | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
rngmultitypid | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
rngconstruct2 | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
rngconstruct3 | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
rngmltconstruct0 | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
rngmltconstruct1 | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
rngmltconstruct2 | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
Version history 3
- PG 18 → 19changed
- PG 13 → 14changed
- PG 9.1 → 9.2added
Definition snapshot: english-manuals:bd7fac6ceceecb78b1d6b8e31ee… · English manual source