M(dot)Mazurek(at)poznan(dot)multinet(dot)pl writes:
> select count (*) from stats group by date_part('dow',data::datetime_;
> I get everthing sortded just as I wanted to, but how can I ad another
> column to know which dow it is?
select date_part('dow',data::datetime), count(*) from stats
group by date_part('dow',data::datetime);
regards, tom lane