↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

range_merge

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

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
range
group label
Range/Multirange Functions And Operators
lang
en
layout
table-new
pages
functions-range.html
prose only
false

Definition PG 18

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

Signatures and overloads

range_merge ( anyrange, anyrange ) → anyrange → anyrange
Computes the smallest range that includes both of the given ranges.
range_merge ( anymultirange ) → anyrange → anyrange
Computes the smallest range that includes the entire multirange.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:f4b2679cd0fdf0eee6811228cb3554794c21523a9fea32915c1fc18e3dda0e49

Text language: en · wiki-repair-20261023:f4b2679cd0fdf0eee6811228cb3554794c21523a9fea32915c1fc18e3dda0e49