{"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","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"],"signature":"range_merge ( anyrange, anyrange ) → anyrange","signature_count":2,"slug":"range-merge","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","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":"2026-09-14T13:14:25.684213+00:00@99e6866c","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":""},{"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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"RANGE-FUNCTIONS-TABLE","file":"functions-range.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"range-merge","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"range_merge","Summary":"计算包含两个给定范围的最小范围。","BodyHTML":"计算包含两个给定范围的最小范围。\u003cpre\u003erange_merge ( anyrange, anyrange ) → anyrange\u003c/pre\u003e计算包含两个给定范围的最小范围。\u003cpre\u003erange_merge ( anymultirange ) → anyrange\u003c/pre\u003e计算包含整个多范围的最小范围。","SourceRevision":"ca936764","ContentHash":"ae9c874b1fd6324d0e3278e4aff0c8402cbbadcf20cd9c151d08e236fd1c97e5","Payload":{"description_zh":"计算包含两个给定范围的最小范围。","description_zh_html":"计算包含两个给定范围的最小范围。","signatures":[{"description_zh":"计算包含两个给定范围的最小范围。","description_zh_html":"计算包含两个给定范围的最小范围。","returns":"anyrange","text":"range_merge ( anyrange, anyrange ) → anyrange","zh_from":"doc"},{"description_zh":"计算包含整个多范围的最小范围。","description_zh_html":"计算包含整个多范围的最小范围。","returns":"anyrange","text":"range_merge ( anymultirange ) → anyrange","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":""}},{"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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}