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

Поиск
Список
Период
Сортировка

DISTINCT and aggregates

От
Brook Milligan
Дата:
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

От
Tom Lane
Дата:
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