PG_RANGE

PG_RANGE records information about range types.

This is in addition to the types' entries in PG_TYPE.

**Table 1** PG_RANGE columns
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
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.

Parent Topic: System Catalogs

Previous topic: PG_PUBLICATION_REL

Next topic: PG_REDACTION_COLUMN