Обсуждение: DISTINCT and aggregates

It seems (in 6.5.2) that one cannot execute queries like:
  select count (distinct foo) from bar;

Am I doing something silly or is this really not supported?

Is there any workaround?  Is this a TODO item?

Cheers,
Brook

Brook Milligan <brook@biology.nmsu.edu> writes:
> It seems (in 6.5.2) that one cannot execute queries like:
>    select count (distinct foo) from bar;

Right.  It's implemented for 7.0...
        regards, tom lane