Home > mailing lists

Re: GROUPing problem - Mailing list pgsql-general

From	Greg Stark
Subject	Re: GROUPing problem
Date	February 23, 2003 05:57:40
Msg-id	87n0knxyx9.fsf@stark.dyndns.tv Whole thread Raw
In response to	Re: GROUPing problem (Dima Tkach <dmitry@openratings.com>)
List	pgsql-general

Tree view

Try

select date_part('year', signedup), date_part('month', signedup),
       count(*)
  from member
 group by date_part('year', signedup), date_part('month', signedup)
 order by date_part('year', signedup), date_part('month', signedup)

--
greg

pgsql-general by date:

From: Dennis Gearon
Date: 23 February 2003, 03:17:37
Subject: 1 to many relationships

From: "Shridhar Daithankar"
Date: 23 February 2003, 05:57:46
Subject: Re: What filesystem?

Re: GROUPing problem - Mailing list pgsql-general

Previous

Next