[GENERAL] Get multiple columns with counts from one table.

2013-06-12 Thread chuydb
Hi,
>From two columns in my table I want to get a unified count for the values in
these columns.
As an example, two columns are:

Table: reports
|   type|   place   |
-
|   one |   home|
|   two |   school  |
|   three   |   work|
|   four|   cafe|
|   five|   friends |
|   six |   mall|
|   one |   work|
|   one |   work|
|   three   |   work|
|   two |   cafe|
|   five|   cafe|
|   one |   home|

If I do:
SELECT type, count(*) from reports
group by type

I get:
|   type|   count   |
--
|   one |   4   |
|   two |   2   |
|   three   |   2   |
|   four|   1   |
|   five|   2   |
|   six |   1   |

Im trying to get something like this: (one column with my types grouped
together and multiple columns with the count vales for each place)
I get:
|   type|   home|   school  |   work|   
cafe|   friends |   mall|
---
|   one |   2   |   |   2   
|   |   |   |
|   two |   |   1   |   
|   1   |   |   |
|   three   |   |   |   2   
|   |   |   |
|   four|   |   |   
|   1   |   |   |
|   five|   |   |   
|   1   |   1   |   |
|   six |   |   |   
|   |   |   1   |

which would be the result of running a count for every place like this:
SELECT type, count(*) from reports where place  = 'home'
group by type
SELECT type, count(*) from reports where place  = 'school'
group by type
SELECT type, count(*) from reports where place  = 'work'
group by type
SELECT type, count(*) from reports where place  = 'cafe'
group by type
SELECT type, count(*) from reports where place  = 'friends'
group by type
SELECT type, count(*) from reports where place  = 'mall'
group by type

Is this possible with postgresql???

Thanks in advance.




--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Get-multiple-columns-with-counts-from-one-table-tp5758977.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Get multiple columns with counts from one table.

2013-06-12 Thread chuydb
Thanks for your quick answer...!
Ill try this out to see if I can get it working.



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Get-multiple-columns-with-counts-from-one-table-tp5758977p5758981.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general