Functions / Range/Multirange Functions And Operators

range_merge

Computes the smallest range that includes both of the given ranges.

Reading PG 18current·documented in 13 of 27 versions, 9.5 to 20

Signatures & examples

range_merge ( anyrange, anyrange ) → anyrange

Computes the smallest range that includes both of the given ranges.

range_merge('[1,2)'::int4range, '[3,4)'::int4range) → [1,4)

range_merge ( anymultirange ) → anyrange

Computes the smallest range that includes the entire multirange.

range_merge('{[1,2), [3,4)}'::int4multirange) → [1,4)

Version history 3

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source