"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.
In response to
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|