looping over multirange segments?

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема looping over multirange segments?
Дата
Msg-id 623b65ef-6bfe-ec35-45c0-341e8f9ab7a8@silentmedia.com
обсуждение исходный текст
Ответы Re: looping over multirange segments?  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ho John Lee
Дата:
Сообщение: Re: How to display stored image as bytea or as large objects?
Следующее
От: Csanyi Pal
Дата:
Сообщение: Re: How to display stored image as bytea or as large objects?