The pg_range catalog provides information about range types.
| Column name | Data type | Description |
|---|---|---|
rngtypid |
oid (references pg_type.oid) |
The OID of the range type. |
rngsubtype |
oid (references pg_type.oid) |
The OID of the element type (subtype) of the range type. |
rngmultitypid |
oid (references pg_type.oid) |
The OID of the multirange type for the range type. |
rngcollation |
oid (references pg_collation.oid) |
The OID of the collation used for range comparisons. 0 – No collation. |
rngsubopc |
oid (references pg_opclass.oid) |
The OID of the subtype’s operator class used for range comparisons. |
rngcanonical |
regproc (references pg_proc.oid) |
The OID of the function that converts a range value into a canonical form. 0 – Not applicable. |
rngsubdiff |
regproc (references pg_proc.oid) |
The OID of the function that returns the difference between two element values as double precision. 0 – Not applicable. |