Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] group by date_part - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] group by date_part
Date
Msg-id 16609.951095145@sss.pgh.pa.us
Whole thread Raw
In response to group by date_part  (M.Mazurek@poznan.multinet.pl)
Responses Re: [SQL] group by date_part  (M.Mazurek@poznan.multinet.pl)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "jdb371"
Date:
Subject: it wont let me delete
Next
From: M.Mazurek@poznan.multinet.pl
Date:
Subject: Re: [SQL] group by date_part