"Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb> writes:

> Any ideas??
> Could this be done with aggregates ??

I think you're going to have to write code that reads all the records, keeps
state representing the current period start and the last seen end date and
outputs data every time it sees a gap like you want.

This could be a set returning plpgsql or plperl or plwhatever function, but it
may be easier to write it in your application level code.

-- 
greg

In response to

• Creating a selective aggregate ?? at 2004-06-30 06:39:29 from Najib Abi Fadel

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2004-07-03 14:54:21
	Subject: Re: nested-xacts cursors (was Re: Performance with new nested-xacts code)
Previous:	From: Michael Brusser	Date: 2004-07-03 14:26:46
	Subject: Re: Adding VERSION to startup log output