{"Entry":{"collection":"func","key":"range-merge","name":"range_merge","aliases":[],"metadata":{"changed_in":["14"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.5"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":false,"doc_overhaul":false,"from":"13","group_changed":null,"signatures":{"added":["range_merge ( anymultirange ) → anyrange"],"removed":[]},"status":"changed","to":"14"}],"content_hash":"55f2e3bfa87af306c62fb58874737d89fdbb091d4dcabab544faff7648314c80","derived_content_hash":"e799aee92cde59c5e46f1a8463440d26d5d491008c9ae79565b4373403f511a0","first_version":"9.5","group":"range","group_label":"Range/Multirange Functions And Operators","groups":["range"],"imported_at":"2026-09-14T21:49:48.841645+08:00","last_version":"20","name":"range_merge","name_key":"range_merge","position":20005,"present_in":["9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"2026-09-14T13:14:25.684213+00:00@99e6866c","receipt_sha256":"273706bc4ef6896cca932b3a865df5599563ee3aac0a9dfced1bc8493c4514b8","repair":"wiki-repair-20261023"},"signature":"range_merge ( anyrange, anyrange ) → anyrange","signature_count":2,"slug":"range-merge","source_rev":"wiki-repair-20261023:f4b2679cd0fdf0eee6811228cb3554794c21523a9fea32915c1fc18e3dda0e49","summary":"Computes the smallest range that includes both of the given ranges.","summary_zh":""}},"Definition":{"Collection":"func","Key":"range-merge","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"range-merge","SourceRevision":"wiki-repair-20261023:f4b2679cd0fdf0eee6811228cb3554794c21523a9fea32915c1fc18e3dda0e49","Facts":{"description":"Computes the smallest range that includes both of the given ranges.","description_html":"Computes the smallest range that includes both of the given ranges.","description_zh":"计算包含两个给定范围的最小范围。","description_zh_html":"计算包含两个给定范围的最小范围。","doc":{"anchor":"RANGE-FUNCTIONS-TABLE","file":"functions-range.html","slug":"18"},"group":"range","group_label":"Range/Multirange Functions And Operators","lang":"en","layout":"table-new","pages":["functions-range.html"],"prose_only":false,"signatures":[{"description":"Computes the smallest range that includes both of the given ranges.","description_html":"Computes the smallest range that includes both of the given ranges.","description_zh":"计算包含两个给定范围的最小范围。","description_zh_html":"计算包含两个给定范围的最小范围。","examples":[{"expr":"range_merge('[1,2)'::int4range, '[3,4)'::int4range)","result":"[1,4)"}],"html":"\u003ccode class=\"function\"\u003erange_merge\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e, \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyrange\u003c/code\u003e","returns":"anyrange","text":"range_merge ( anyrange, anyrange ) → anyrange","zh_from":"same-version-pgdoc"},{"description":"Computes the smallest range that includes the entire multirange.","description_html":"Computes the smallest range that includes the entire multirange.","description_zh":"计算包含整个多范围的最小范围。","description_zh_html":"计算包含整个多范围的最小范围。","examples":[{"expr":"range_merge('{[1,2), [3,4)}'::int4multirange)","result":"[1,4)"}],"html":"\u003ccode class=\"function\"\u003erange_merge\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanymultirange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyrange\u003c/code\u003e","returns":"anyrange","text":"range_merge ( anymultirange ) → anyrange","zh_from":"same-version-pgdoc"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-range.html","sha256":"b73f791c20302cc0829ee9258b142e015751fcaae5a06812a62aeadff47962c7"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"RANGE-FUNCTIONS-TABLE","file":"functions-range.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"range-merge","SourceDatabase":"center","Version":"18","Locale":"en","Title":"range_merge","Summary":"Computes the smallest range that includes both of the given ranges.","BodyHTML":"Computes the smallest range that includes both of the given ranges.","SourceRevision":"wiki-repair-20261023:f4b2679cd0fdf0eee6811228cb3554794c21523a9fea32915c1fc18e3dda0e49","ContentHash":"6ce21358201d690a6672400f20b8914faa173e8eb82bad318990bfb99b353ac3","Payload":{"description":"Computes the smallest range that includes both of the given ranges.","description_html":"Computes the smallest range that includes both of the given ranges.","signatures":[{"description":"Computes the smallest range that includes both of the given ranges.","description_html":"Computes the smallest range that includes both of the given ranges.","description_zh":"计算包含两个给定范围的最小范围。","description_zh_html":"计算包含两个给定范围的最小范围。","examples":[{"expr":"range_merge('[1,2)'::int4range, '[3,4)'::int4range)","result":"[1,4)"}],"html":"\u003ccode class=\"function\"\u003erange_merge\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e, \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyrange\u003c/code\u003e","returns":"anyrange","text":"range_merge ( anyrange, anyrange ) → anyrange","zh_from":"same-version-pgdoc"},{"description":"Computes the smallest range that includes the entire multirange.","description_html":"Computes the smallest range that includes the entire multirange.","description_zh":"计算包含整个多范围的最小范围。","description_zh_html":"计算包含整个多范围的最小范围。","examples":[{"expr":"range_merge('{[1,2), [3,4)}'::int4multirange)","result":"[1,4)"}],"html":"\u003ccode class=\"function\"\u003erange_merge\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanymultirange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyrange\u003c/code\u003e","returns":"anyrange","text":"range_merge ( anymultirange ) → anyrange","zh_from":"same-version-pgdoc"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"7490e76ab721bcdb4d63e33f7526b46168be6cc78ed6601b579b08e0e3abc81f","Text":"range_merge ( anyrange, anyrange ) → anyrange","Returns":"anyrange","Payload":{"description":"Computes the smallest range that includes both of the given ranges.","description_html":"Computes the smallest range that includes both of the given ranges.","description_zh":"计算包含两个给定范围的最小范围。","description_zh_html":"计算包含两个给定范围的最小范围。","examples":[{"expr":"range_merge('[1,2)'::int4range, '[3,4)'::int4range)","result":"[1,4)"}],"html":"\u003ccode class=\"function\"\u003erange_merge\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e, \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyrange\u003c/code\u003e","returns":"anyrange","text":"range_merge ( anyrange, anyrange ) → anyrange","zh_from":"same-version-pgdoc"}},{"Version":"18","Ordinal":1,"Hash":"c2abd535667d1f42177533d5aa7ec6baa0dd2e65ff80255f0ee3cf46bcf7d3b7","Text":"range_merge ( anymultirange ) → anyrange","Returns":"anyrange","Payload":{"description":"Computes the smallest range that includes the entire multirange.","description_html":"Computes the smallest range that includes the entire multirange.","description_zh":"计算包含整个多范围的最小范围。","description_zh_html":"计算包含整个多范围的最小范围。","examples":[{"expr":"range_merge('{[1,2), [3,4)}'::int4multirange)","result":"[1,4)"}],"html":"\u003ccode class=\"function\"\u003erange_merge\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanymultirange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyrange\u003c/code\u003e","returns":"anyrange","text":"range_merge ( anymultirange ) → anyrange","zh_from":"same-version-pgdoc"}}],"Spellings":null,"SQLState":null,"Evidence":null}