On Sat, 4 Jun 2022 at 22:56, Thiemo Kellner <thiemo@xxxxxxxxxxxxxxxxxxxx> wrote:
Hi Robert
Interesting problem. I need to think about it.
You need to figure out when Input changes. You can achieve this by using lead or lag (depending of the sort direction over start) https://www.postgresql.org/docs/current/functions-window.html .
After a bit of poking around this seems to get things going in the right direction.
select row_number() over (order by start) - row_number() over (partition by input order by start)
