Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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 ??


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group