dividing time ??

From: "Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb>
To: "generalpost" <pgsql-general(at)postgresql(dot)org>
Subject: dividing time ??
Date: 2004-06-29 07:47:45
Message-ID: 004a01c45dad$60bbeaf0$9d64a8c0@najib
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
i have a table of dates let's say:

1/1/2004
8/1/2004
15/1/2004
29/1/2004
5/2/2004
12/2/2004

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

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

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2004-06-29 09:51:41 Re: A few beginner's questions concerning concurrency control
Previous Message CSN 2004-06-29 06:56:15 dup(0) failed after 3195 successes: Bad file descriptor