Misa Simic <misa.simic@gmail.com> wrote:
> So I wonder - is there some kind of aggregate window function
> what does desired results?
Not built in, but PostgreSQL makes it pretty easy to do so. With a
little effort to define your own aggregate function, your query can
look like this:
SELECT
thing_id,
category,
int4range_list(period_id)
FROM thing
GROUP BY thing_id, category
ORDER BY 1, 2;
I've attached a couple files -- one which creates the desired
aggregate function, and the other loads a table with two of your
sample data sets and runs the above. This is just intended as a
quick example of the capabilities available to you.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company