1 #----------------------------------------------------------------------
4 # Initial contents of the pg_range system catalog.
6 # Portions Copyright (c) 1996-2025, PostgreSQL Global Development Group
7 # Portions Copyright (c) 1994, Regents of the University of California
9 # src/include/catalog/pg_range.dat
11 #----------------------------------------------------------------------
15 { rngtypid
=> 'int4range', rngsubtype
=> 'int4',
16 rngmultitypid
=> 'int4multirange', rngsubopc
=> 'btree/int4_ops',
17 rngcanonical
=> 'int4range_canonical', rngsubdiff
=> 'int4range_subdiff' },
18 { rngtypid
=> 'numrange', rngsubtype
=> 'numeric',
19 rngmultitypid
=> 'nummultirange', rngsubopc
=> 'btree/numeric_ops',
20 rngcanonical
=> '-', rngsubdiff
=> 'numrange_subdiff' },
21 { rngtypid
=> 'tsrange', rngsubtype
=> 'timestamp',
22 rngmultitypid
=> 'tsmultirange', rngsubopc
=> 'btree/timestamp_ops',
23 rngcanonical
=> '-', rngsubdiff
=> 'tsrange_subdiff' },
24 { rngtypid
=> 'tstzrange', rngsubtype
=> 'timestamptz',
25 rngmultitypid
=> 'tstzmultirange', rngsubopc
=> 'btree/timestamptz_ops',
26 rngcanonical
=> '-', rngsubdiff
=> 'tstzrange_subdiff' },
27 { rngtypid
=> 'daterange', rngsubtype
=> 'date',
28 rngmultitypid
=> 'datemultirange', rngsubopc
=> 'btree/date_ops',
29 rngcanonical
=> 'daterange_canonical', rngsubdiff
=> 'daterange_subdiff' },
30 { rngtypid
=> 'int8range', rngsubtype
=> 'int8',
31 rngmultitypid
=> 'int8multirange', rngsubopc
=> 'btree/int8_ops',
32 rngcanonical
=> 'int8range_canonical', rngsubdiff
=> 'int8range_subdiff' },