Re: COUNT(Distinct city) HELP!!! - Mailing list pgsql-general

or u can also try

select count(*)
from
    (select distinct city from ct);

Hope this helps
Anand

On Mon, Dec 25, 2000 at 05:27:30PM -0800, Stephan Szabo wrote:
>
>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
>>