Home > mailing lists

Creating a selective aggregate ?? - Mailing list pgsql-hackers

From	Najib Abi Fadel
Subject	Creating a selective aggregate ??
Date	July 1, 2004 22:43:39
Msg-id	001c01c45e6d$01f47260$9d64a8c0@najib Whole thread Raw
Responses	Re: Creating a selective aggregate ?? Re: Creating a selective aggregate ??
List	pgsql-hackers

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: Alvaro Herrera
Date: 01 July 2004, 22:41:06
Subject: Re: Nested Transactions, Abort All

From: Alvaro Herrera
Date: 01 July 2004, 22:57:17
Subject: Re: suggestion: set default statistics to 100 for numerics