Re: looping over multirange segments? - Mailing list pgsql-general

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!