multirange

A data type for storing multiple non-overlapping ranges
This entry relates to a PostgreSQL feature which is part of PostgreSQL 14, due to be released in late 2021.

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