Re: Need magic for a moving statistic

In response to Andreas :
> 
> A. Kretschmer schrieb:
> >[...] Or simpler:
> >
> >test=*# select  ((d-'2009-10-02'::date)/14) || '. period' as period, 
> >sum(value) from foo group by 1;
> >  
> This is tricky, because you use a text-column to sort but need numerical 
> sorting since there will be more than 0-9 periods.

Yes, sure. Use ((d-'2009-10-02'::date)/14) instead for order. My fault.

> 
> This is still the way to handle the periodity without pulling out some 
> external skript language.
> Thanks for the reply.   :)

Glad to help you ;-)
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)