I believe that functionality was added in version 7.0,
are you using an earlier version?
On Mon, 25 Dec 2000, Abe wrote:
> Hey there,
>
> I get this error but I think this is supposed to work:
>
> The table has some duplicates such as Munich I want the number of distinct cities:
>
> abenew=> select * from ct;
> name| age| city
> ---- +--- +------
> jow | 10| london
> tim | 15| paris
> kim | 17| munich
> te | 19| munich
> (8 rows)
>
> My query is as follows:
>
> tester => select count(distinct city) from ct;
> ERROR: parser: parse error at or near "distinct"
>
> Any guidance would be appreciated...
> Thanks
> Abe
>