From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/catalog-pg-range.html | 61 +++++++++++++++++++++++++++++++++ 1 file changed, 61 insertions(+) create mode 100644 doc/src/sgml/html/catalog-pg-range.html (limited to 'doc/src/sgml/html/catalog-pg-range.html') diff --git a/doc/src/sgml/html/catalog-pg-range.html b/doc/src/sgml/html/catalog-pg-range.html new file mode 100644 index 0000000..69d0327 --- /dev/null +++ b/doc/src/sgml/html/catalog-pg-range.html @@ -0,0 +1,61 @@ + +53.43. pg_range
53.43. pg_range
Prev UpChapter 53. System CatalogsHome Next

53.43. pg_range

+ The catalog pg_range stores information about + range types. This is in addition to the types' entries in + pg_type. +

Table 53.43. pg_range Columns

+ Column Type +

+

+ Description +

+ rngtypid oid + (references pg_type.oid) +

+

+ OID of the range type +

+ rngsubtype oid + (references pg_type.oid) +

+

+ OID of the element type (subtype) of this range type +

+ rngmultitypid oid + (references pg_type.oid) +

+

+ OID of the multirange type for this range type +

+ rngcollation oid + (references pg_collation.oid) +

+

+ OID of the collation used for range comparisons, or zero if none +

+ rngsubopc oid + (references pg_opclass.oid) +

+

+ OID of the subtype's operator class used for range comparisons +

+ rngcanonical regproc + (references pg_proc.oid) +

+

+ OID of the function to convert a range value into canonical form, + or zero if none +

+ rngsubdiff regproc + (references pg_proc.oid) +

+

+ OID of the function to return the difference between two element + values as double precision, or zero 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. rngsubdiff is optional but should be supplied to + improve performance of GiST indexes on the range type. +

Prev Up Next
53.42. pg_publication_rel Home 53.44. pg_replication_origin
\ No newline at end of file -- cgit v1.2.3