{"Entry":{"collection":"func","key":"multirange-minus-multi","name":"multirange_minus_multi","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"18","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"19"}],"content_hash":"3d2a44c472d4151378349024e7eac4f505c3234a4ca97cf6f1bf4f537b48afe5","first_version":"19","group":"range","group_label":"Range/Multirange Functions And Operators","groups":["range"],"imported_at":"2026-09-14T21:49:48.841253+08:00","last_version":"20","name":"multirange_minus_multi","name_key":"multirange_minus_multi","position":20004,"present_in":["19","20"],"signature":"multirange_minus_multi ( anymultirange, anymultirange ) → setof anymultirange","signature_count":1,"slug":"multirange-minus-multi","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","summary":"Returns the non-empty multirange(s) remaining after subtracting the second multirange from the first.","summary_zh":""}},"Definition":{"Collection":"func","Key":"multirange-minus-multi","SourceDatabase":"center","Version":"20","SourceTable":"func","SourceKey":"multirange-minus-multi","SourceRevision":"2026-09-14T13:14:25.684213+00:00@99e6866c","Facts":{"description":"Returns the non-empty multirange(s) remaining after subtracting the second multirange from the first. If the subtraction yields an empty multirange, no rows are returned. Two rows are never returned, because a single multirange can always accommodate any result.","description_html":"Returns the non-empty multirange(s) remaining after subtracting the second multirange from the first. If the subtraction yields an empty multirange, no rows are returned. Two rows are never returned, because a single multirange can always accommodate any result.","description_zh":"","description_zh_html":"","doc":{"anchor":"MULTIRANGE-FUNCTIONS-TABLE","file":"functions-range.html","slug":"devel"},"group":"range","group_label":"Range/Multirange Functions And Operators","lang":"en","layout":"table-new","pages":["functions-range.html"],"prose_only":false,"signatures":[{"description":"Returns the non-empty multirange(s) remaining after subtracting the second multirange from the first. If the subtraction yields an empty multirange, no rows are returned. Two rows are never returned, because a single multirange can always accommodate any result.","description_html":"Returns the non-empty multirange(s) remaining after subtracting the second multirange from the first. If the subtraction yields an empty multirange, no rows are returned. Two rows are never returned, because a single multirange can always accommodate any result.","description_zh":"","description_zh_html":"","examples":[{"expr":"multirange_minus_multi('{[0,10)}'::int4multirange, '{[3,4)}'::int4multirange)","result":"{[0,3), [4,10)}"}],"html":"\u003ccode class=\"function\"\u003emultirange_minus_multi\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanymultirange\u003c/code\u003e, \u003ccode class=\"type\"\u003eanymultirange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof anymultirange\u003c/code\u003e","returns":"setof anymultirange","text":"multirange_minus_multi ( anymultirange, anymultirange ) → setof anymultirange","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"MULTIRANGE-FUNCTIONS-TABLE","file":"functions-range.html","slug":"devel"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"multirange-minus-multi","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"multirange_minus_multi","Summary":"返回从第一个多范围中减去第二个多范围后剩下的非空多范围。如果减法得到空多范围，则不会返回任何行。永远不会返回两行，因为单个多范围总能容纳任何结果。","BodyHTML":"返回从第一个多范围中减去第二个多范围后剩下的非空多范围。如果减法得到空多范围，则不会返回任何行。永远不会返回两行，因为单个多范围总能容纳任何结果。\u003cpre\u003emultirange_minus_multi ( anymultirange, anymultirange ) → setof anymultirange\u003c/pre\u003e返回从第一个多范围中减去第二个多范围后剩下的非空多范围。如果减法得到空多范围，则不会返回任何行。永远不会返回两行，因为单个多范围总能容纳任何结果。","SourceRevision":"2026-09-12T08:18:26.491985+00:00@e2a86b52","ContentHash":"e3413ff90810077bd9832525536dee09bc3d0adf87968a8d3db4407d51b17c40","Payload":{"description_zh":"返回从第一个多范围中减去第二个多范围后剩下的非空多范围。如果减法得到空多范围，则不会返回任何行。永远不会返回两行，因为单个多范围总能容纳任何结果。","description_zh_html":"返回从第一个多范围中减去第二个多范围后剩下的非空多范围。如果减法得到空多范围，则不会返回任何行。永远不会返回两行，因为单个多范围总能容纳任何结果。","signatures":[{"description_zh":"返回从第一个多范围中减去第二个多范围后剩下的非空多范围。如果减法得到空多范围，则不会返回任何行。永远不会返回两行，因为单个多范围总能容纳任何结果。","description_zh_html":"返回从第一个多范围中减去第二个多范围后剩下的非空多范围。如果减法得到空多范围，则不会返回任何行。永远不会返回两行，因为单个多范围总能容纳任何结果。","returns":"setof anymultirange","text":"multirange_minus_multi ( anymultirange, anymultirange ) → setof anymultirange","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"20","Ordinal":0,"Hash":"e3f072567ff9760c6cf3006fff062f4d780afb2360c70fcae18af05099b9d191","Text":"multirange_minus_multi ( anymultirange, anymultirange ) → setof anymultirange","Returns":"setof anymultirange","Payload":{"description":"Returns the non-empty multirange(s) remaining after subtracting the second multirange from the first. If the subtraction yields an empty multirange, no rows are returned. Two rows are never returned, because a single multirange can always accommodate any result.","description_html":"Returns the non-empty multirange(s) remaining after subtracting the second multirange from the first. If the subtraction yields an empty multirange, no rows are returned. Two rows are never returned, because a single multirange can always accommodate any result.","description_zh":"","description_zh_html":"","examples":[{"expr":"multirange_minus_multi('{[0,10)}'::int4multirange, '{[3,4)}'::int4multirange)","result":"{[0,3), [4,10)}"}],"html":"\u003ccode class=\"function\"\u003emultirange_minus_multi\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanymultirange\u003c/code\u003e, \u003ccode class=\"type\"\u003eanymultirange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof anymultirange\u003c/code\u003e","returns":"setof anymultirange","text":"multirange_minus_multi ( anymultirange, anymultirange ) → setof anymultirange","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}