Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_RANGE

PG_RANGE

Updated at:Jul 15, 2020 GMT+08:00

PG_RANGE records information about range types.

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

Table 1 PG_RANGE columns

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel