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

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

2013-06-12 Thread Sergey Konoplev
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|

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

2013-06-12 Thread Alban Hertroys
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 | > - > |

[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