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.
Last Article: PG_PROC
Next Article: PG_REDACTION_COLUMN
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.