pg_range
The catalog pg_range
stores information about
range types. This is in addition to the types' entries in
pg_type
.
Table 48.53. pg_range
Columns
Column Type Description |
---|
OID of the range type |
OID of the element type (subtype) of this range type |
OID of the collation used for range comparisons, or 0 if none |
OID of the subtype's operator class used for range comparisons |
OID of the function to convert a range value into canonical form, or 0 if none |
OID of the function to return the difference between two element
values as |
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.