I'm really, really liking the multirange types in PG14. Thank you for
making them! Unfortunately I am struggling with how to loop over the
segments of a multirange. There doesn't seem to be a way to convert them
to arrays, and I can't just use plpgsql's FOREACH on one. Am I missing
something obvious? It seems like a reasonable thing to want to do.
FWIW, my actual end goal is to take something like this:
select int8range(1,10)::int8multirange - int8range(4,6)::int8multirange;
?column?
────────────────
{[1,4),[6,10)}
...and turn it into this:
select ???;
int8range │ ?column?
───────────┼──────────
[1,4) │ 0
[6,10) │ 0
