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) -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
