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.
This is still the way to handle the periodity without pulling out some
external skript language.
Thanks for the reply. :)