2013/12/13 Kevin Grittner <kgrittn@xxxxxxxxx>
Misa Simic <misa.simic@xxxxxxxxx> wrote:Not built in, but PostgreSQL makes it pretty easy to do so. With a
> So I wonder - is there some kind of aggregate window function
> what does desired results?
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
Many thanks Kevin! :)
It simply works - perfect! :)
Many thanks,
Misa
