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
- PostgreSQL 14
- added (commit 6df7a969)
References
- PostgreSQL 14 documentation: Built-in Range and Multirange Types
- PostgreSQL 14 documentation: Multirange Operators
- PostgreSQL 14 documentation: Multirange Functions
Useful links
- Waiting for PostgreSQL 14 – Multirange datatypes - December 2020 blog article by depesz.com
Categories
See also
range, pg_range