pg_range.dat 1.5 KB

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