On Sep 30, 2:36 am, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> > SELECT count_unique(make), count_unique(color) from table WHERE >criteria<;
> I must be missing something, because I don't see why you couldn't do
> SELECT count(distinct make), count(distinct color) from table WHERE >criteria<;
I didn't explain well, I want the count of each distinct value in a
column, eg, if the color column has 50 rows, 20x'red', 10x'green',
20x'blue' - it will give me those results.
SELECT count(distinct color) would return 3 - which is the count of
distinct values, which is not what I want.
In response to
pgsql-general by date
|Next:||From: r_musta||Date: 2008-09-30 06:59:50|
|Subject: Re: Counting unique rows as an aggregate.|
|Previous:||From: A. Kretschmer||Date: 2008-09-30 06:52:38|
|Subject: Re: dbsamples from pgfoundry|