PG_RANGE
PG_RANGE records information about range types.
This is in addition to the types' entries in PG_TYPE.
| Column | 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 rngsubopc (plus rngcollation, if the element type is collatable) determines the sort ordering used by the range type. |
| rngcanonical | regproc | PG_PROC.oid | OID of the function to convert a range value into canonical form, or 0 if none. rngcanonical is used when the element type is discrete. |
| rngsubdiff | regproc | PG_PROC.oid | OID of the function to return the difference between two element values as double precision, or 0 if none |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
