Robert Stanford <rstanford@gmail.com> writes:
> Can anyone suggest an elegant way to coalesce consecutive rows so only the
> first start time and last end time for each group of events (by input) is
> returned.
Window functions don't change the number of query result rows, so that
idea is a dead end. The standard way to solve this is GROUP BY:
SELECT Input, MIN(Start) AS Start, MAX(End) AS End
FROM ...
GROUP BY Input
ORDER BY Input -- optional
If MIN/MAX don't quite express what you need to happen, then you
might need to write custom aggregates. Point though is that
you want aggregation within GROUP BY groups, not windowing.
regards, tom lane
