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
- 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