Lu, Huayi
a24ca60074
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
7.3 KiB
PG_RANGE
PG_RANGE records information about range types.
This is in addition to the types' entries in PG_TYPE.
Name |
Type |
Reference |
Description |
|---|---|---|---|
rngtypid |
oid |
PG_TYPE.oid |
OID of the range type |
rngsubtype |
oid |
PG_TYPE.oid |
OID of the element type (subtype) of this range type |
rngcollation |
oid |
PG_COLLATION.oid |
OID of the collation used for range comparisons, or 0 if none |
rngsubopc |
oid |
PG_OPCLASS.oid |
OID of the subtype's operator class used for range comparisons |
rngcanonical |
regproc |
PG_PROC.oid |
OID of the function to convert a range value into canonical form, or 0 if none |
rngsubdiff |
regproc |
PG_PROC.oid |
OID of the function to return the difference between two element values as double precision, or 0 if none |
rngsubopc (plus rngcollation, if the element type is collatable) determines the sort ordering used by the range type. rngcanonical is used when the element type is discrete.