"Najib Abi Fadel" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
