Re: GROUP BY overlapping (tsrange) entries

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: GROUP BY overlapping (tsrange) entries
Дата
Msg-id CAKFQuwY2ufhz5c1KM6Cypcog=0zKqfiirkW7GS7V0VFMeehkxw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: GROUP BY overlapping (tsrange) entries  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-sql
On Fri, Jan 29, 2016 at 4:34 PM, Andreas Joseph Krogh <andreas@visena.com> wrote:
På fredag 29. januar 2016 kl. 20:23:01, skrev David G. Johnston <david.g.johnston@gmail.com>:
The only other potential query approach that comes to mind is some kind of recursive CTE.
 
Interesting. Care to give an example of how to solve this using recursive CTE?

My skill with recursive CTEs is abyssmal, so no, that is not a challenge that I wish to take on at this time.  I'm not positive there is a meaningful one to even be had but the idea of choosing a parent time and then either expanding its covered range or adding a child is at least compelling enough to make it worth exploring if current solutions are undesirable.

David J.

 

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

Предыдущее
От: Michael Moore
Дата:
Сообщение: Re: GROUP BY overlapping (tsrange) entries
Следующее
От: Misa Simic
Дата:
Сообщение: Re: GROUP BY overlapping (tsrange) entries