Home > mailing lists

dividing time ?? - Mailing list pgsql-general

From	Najib Abi Fadel
Subject	dividing time ??
Date	June 29, 2004 06:50:14
Msg-id	004a01c45dad$60bbeaf0$9d64a8c0@najib Whole thread Raw
List	pgsql-general

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 ??

From: Justin Clift
Date: 29 June 2004, 06:39:27
Subject: Re: How to determine field names in a trigger?

From: Yoram Biberman
Date: 29 June 2004, 08:56:08
Subject: A few beginner's questions concerning concurrency control