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 >
