Re: GROUP BY overlapping (tsrange) entries

On Fri, Jan 29, 2016 at 4:34 PM, Andreas Joseph Krogh <andreas(at)visena(dot)com>
wrote:

> På fredag 29. januar 2016 kl. 20:23:01, skrev David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)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.