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