Postgres Pro
Downloads
Home   >   mailing lists

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

From Najib Abi Fadel
Subject Creating a selective aggregate ??
Date
Msg-id 001c01c45e6d$01f47260$9d64a8c0@najib
Whole thread Raw
Responses Re: Creating a selective aggregate ??  (Greg Stark <gsstark@mit.edu>)
Re: Creating a selective aggregate ??  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers
Tree view
 
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-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Nested Transactions, Abort All
Next
From: Alvaro Herrera
Date:
Subject: Re: suggestion: set default statistics to 100 for numerics