i have a table of dates let's say:
I am searching for a way to have the minimum date and maximum date for dates seperated by one week whitout gaps between them.
which will give the following output:
1/1/2004 , 15/1/2004
29/1/2004 , 12/2/2004
Could this be done with aggregates ??
pgsql-general by date
|Next:||From: Karsten Hilbert||Date: 2004-06-29 09:51:41|
|Subject: Re: A few beginner's questions concerning concurrency control|
|Previous:||From: CSN||Date: 2004-06-29 06:56:15|
|Subject: dup(0) failed after 3195 successes: Bad file descriptor|