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
On Wed, Jun 12, 2013 at 3:09 PM, chuydb wrote:
> 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|
On Jun 13, 2013, at 24:09, chuydb wrote:
> 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 |
> -
> |
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