I have a table with Date and unit column. . I want to find sum of unit column
considering 3 days each

User will specify start and enddate

Eg 

Date            Unit
10/1/2011     1
10/2/2011     2
10/3/2011      3
10/4/2011     4
10/5/2011     4
10/6/2011     1
10/7/2011     2 
10/8/2011     3
10/9/2011     1
10/10/2011    1
10/11/2011    1
suppose if user selects date 10/1/2011  to 10/6/2011

then output should be
 
start date      enddate         unit
10/1/2011      10/3/2011     6
10/4/2011       10/6/2011    9


pls let me know if anybody has any idea.

Thanks in advance 


--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Group-by-on-Date-tp4904685p4904685.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to