range_merge ( anyrange, anyrange ) → anyrangeComputes the smallest range that includes both of the given ranges.
range_merge('[1,2)'::int4range, '[3,4)'::int4range) → [1,4)FUNCTIONS / RANGE/MULTIRANGE FUNCTIONS AND OPERATORS
range_merge
Read PG 18 manual ↗Computes the smallest range that includes both of the given ranges.
Signatures & examples
range_merge ( anymultirange ) → anyrangeComputes the smallest range that includes the entire multirange.
range_merge('{[1,2), [3,4)}'::int4multirange) → [1,4)Version history 3
- PG 13 → 14changed
- PG 12 → 13changed
- PG 9.4 → 9.5added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source