{"Entry":{"collection":"func","key":"range-minus-multi","name":"range_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":"7db53b6cb610e7266dd903fcf888b3a2e152a2d93c2567bfb4bd5d1d4ee85604","first_version":"19","group":"range","group_label":"Range/Multirange Functions And Operators","groups":["range"],"imported_at":"2026-09-14T21:49:48.842176+08:00","last_version":"20","name":"range_minus_multi","name_key":"range_minus_multi","position":20006,"present_in":["19","20"],"signature":"range_minus_multi ( anyrange, anyrange ) → setof anyrange","signature_count":1,"slug":"range-minus-multi","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","summary":"Returns the non-empty range(s) remaining after subtracting the second range from the first.","summary_zh":""}},"Definition":{"Collection":"func","Key":"range-minus-multi","SourceDatabase":"center","Version":"20","SourceTable":"func","SourceKey":"range-minus-multi","SourceRevision":"2026-09-14T13:14:25.684213+00:00@99e6866c","Facts":{"description":"Returns the non-empty range(s) remaining after subtracting the second range from the first. One row is returned for each range, so if the second range splits the first into two parts, there will be two results. If the subtraction yields an empty range, no rows are returned.","description_html":"Returns the non-empty range(s) remaining after subtracting the second range from the first. One row is returned for each range, so if the second range splits the first into two parts, there will be two results. If the subtraction yields an empty range, no rows are returned.","description_zh":"","description_zh_html":"","doc":{"anchor":"RANGE-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 range(s) remaining after subtracting the second range from the first. One row is returned for each range, so if the second range splits the first into two parts, there will be two results. If the subtraction yields an empty range, no rows are returned.","description_html":"Returns the non-empty range(s) remaining after subtracting the second range from the first. One row is returned for each range, so if the second range splits the first into two parts, there will be two results. If the subtraction yields an empty range, no rows are returned.","description_zh":"","description_zh_html":"","examples":[{"expr":"range_minus_multi('[0,10)'::int4range, '[3,4)'::int4range)","result":"[0,3)\n[4,10)"}],"html":"\u003ccode class=\"function\"\u003erange_minus_multi\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e, \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof anyrange\u003c/code\u003e","returns":"setof anyrange","text":"range_minus_multi ( anyrange, anyrange ) → setof anyrange","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"RANGE-FUNCTIONS-TABLE","file":"functions-range.html","slug":"devel"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"range-minus-multi","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"range_minus_multi","Summary":"返回从第一个范围中减去第二个范围后剩下的非空范围。每个范围返回一行，因此如果第二个范围将第一个范围分成两部分，就会有两个结果。如果减法得到空范围，则不会返回任何行。","BodyHTML":"返回从第一个范围中减去第二个范围后剩下的非空范围。每个范围返回一行，因此如果第二个范围将第一个范围分成两部分，就会有两个结果。如果减法得到空范围，则不会返回任何行。\u003cpre\u003erange_minus_multi ( anyrange, anyrange ) → setof anyrange\u003c/pre\u003e返回从第一个范围中减去第二个范围后剩下的非空范围。每个范围返回一行，因此如果第二个范围将第一个范围分成两部分，就会有两个结果。如果减法得到空范围，则不会返回任何行。","SourceRevision":"2026-09-12T08:18:26.491985+00:00@e2a86b52","ContentHash":"d522c922cd877929e50d1f47e62189232c5a3f98a190da9ec92c049a70fa8afe","Payload":{"description_zh":"返回从第一个范围中减去第二个范围后剩下的非空范围。每个范围返回一行，因此如果第二个范围将第一个范围分成两部分，就会有两个结果。如果减法得到空范围，则不会返回任何行。","description_zh_html":"返回从第一个范围中减去第二个范围后剩下的非空范围。每个范围返回一行，因此如果第二个范围将第一个范围分成两部分，就会有两个结果。如果减法得到空范围，则不会返回任何行。","signatures":[{"description_zh":"返回从第一个范围中减去第二个范围后剩下的非空范围。每个范围返回一行，因此如果第二个范围将第一个范围分成两部分，就会有两个结果。如果减法得到空范围，则不会返回任何行。","description_zh_html":"返回从第一个范围中减去第二个范围后剩下的非空范围。每个范围返回一行，因此如果第二个范围将第一个范围分成两部分，就会有两个结果。如果减法得到空范围，则不会返回任何行。","returns":"setof anyrange","text":"range_minus_multi ( anyrange, anyrange ) → setof anyrange","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"20","Ordinal":0,"Hash":"8b38b2cb96cddacdd36062ef6c2340f2066bfabce09485fb970b6c17c5f1be79","Text":"range_minus_multi ( anyrange, anyrange ) → setof anyrange","Returns":"setof anyrange","Payload":{"description":"Returns the non-empty range(s) remaining after subtracting the second range from the first. One row is returned for each range, so if the second range splits the first into two parts, there will be two results. If the subtraction yields an empty range, no rows are returned.","description_html":"Returns the non-empty range(s) remaining after subtracting the second range from the first. One row is returned for each range, so if the second range splits the first into two parts, there will be two results. If the subtraction yields an empty range, no rows are returned.","description_zh":"","description_zh_html":"","examples":[{"expr":"range_minus_multi('[0,10)'::int4range, '[3,4)'::int4range)","result":"[0,3)\n[4,10)"}],"html":"\u003ccode class=\"function\"\u003erange_minus_multi\u003c/code\u003e ( \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e, \u003ccode class=\"type\"\u003eanyrange\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof anyrange\u003c/code\u003e","returns":"setof anyrange","text":"range_minus_multi ( anyrange, anyrange ) → setof anyrange","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}