Re: [SQL] group by date_part

M.Mazurek@poznan.multinet.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 statsgroup by date_part('dow',data::datetime);
        regards, tom lane