multirange

A data type for storing multiple non-overlapping ranges

multirange is a data type for storing multiple non-overlapping ranges.

The multirange data type was added in PostgreSQL 14..

Usage

Functions

Following functions are available for use with multirange types (PostgreSQL 14 and later):

  • isempty()
  • lower(anymultirange)
  • lower_inc()
  • lower_inf()
  • multirange()
  • range_merge()
  • upper(anymultirange)
  • upper_inc()
  • upper_inf()

Change history

Categories

Data type

See also

range, pg_range