hubert depesz lubaczewski wrote on 7/15/21 5:15 AM:
select * from regexp_matches(_YOUR_MULTIRANGE_::text, '[\[(][^\])]+[\])]', 'g'); I wrote more, including explanation, and ready-to-use function, in here: https://www.depesz.com/2021/07/15/how-to-get-list-of-elements-from-multiranges/
So ugly.... and also so effective for my use case. Thanks!
