Thread: DISTINCT and aggregates

DISTINCT and aggregates

From

Brook Milligan

Date:

21 January 2000, 12:00:45

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

Re: [SQL] DISTINCT and aggregates

From

Tom Lane

Date:

21 January 2000, 13:38:47

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