2013/12/13 Kevin Grittner <kgri...@ymail.com> > Misa Simic <misa.si...@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
Many thanks Kevin! :) It simply works - perfect! :) Many thanks, Misa