looking for suggestions - Mailing list pgsql-general

From Kevin Heflin
Subject looking for suggestions
Date
Msg-id Pine.LNX.4.10.9908232103450.15190-100000@mercury.shreve.net
Whole thread Raw
Responses Re: [GENERAL] looking for suggestions  (Stuart Rison <stuart@ludwig.ucl.ac.uk>)
List pgsql-general
I've got a single table which lists usernames, addressinfo and signup
dates

signup date is data type 'date'

I'm wondering if it's possible through the magic of SQL to run a query
like:

select * from table where signupdate > '01/01/1999' and < '04/01/1999';

then in the results, I would like to break this down by months. So I can
show total signups for january 1999, then February 1999 etc..


Kevin





--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #175    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------


pgsql-general by date:

Previous
From: "Jablonski, David"
Date:
Subject: RE: [GENERAL] Remote PSQL...
Next
From: "Dan Wilson"
Date:
Subject: Re: [GENERAL] PostgreSQL, Java, Linux