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.