Re: Tabulate data incrementally

[Omar Eljumaily <omar2@xxxxxxxxxxxx>]

Thanks Alvaro.  That's good to know.  Actually I was spacing on the need 
for this.  The date_trunc function with group by actually works for me.

select sum(amount), date_trunc('week', period_end) as dt from time_data 
group by dt;


Alvaro Herrera wrote:
> Omar Eljumaily wrote:
>   
> > Thanks Tom and Richard for the tip on date_trunc.  Is it possible in an 
> > sql select statement to create an iterator? 
> >     
>
> Yes, use the generate_series() function.
>
>