SELECT COUNT(DISTINCT) - Mailing list pgsql-hackers

From Oleg Broytmann
Subject SELECT COUNT(DISTINCT)
Date
Msg-id Pine.SOL2.3.96.SK.990222161946.6443A-100000@sun.med.ru
Whole thread Raw
Responses Re: [HACKERS] SELECT COUNT(DISTINCT)  (Andy Selle <aselle@earth.mat.net>)
List pgsql-hackers
Hello!
  I am trying to execute query:
SELECT city_id, COUNT(DISTINCT pos_id)  ...
GROUP BY city_id ;
  but got the error:
ERROR:  parser: parse error at or near "distinct"
  It is me who do not understand SQL or postgres does not implement it?

Oleg.
----    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net          Programmers don't die, they
justGOSUB without RETURN.
 



pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] trouble with rules
Next
From: Andy Selle
Date:
Subject: Re: [HACKERS] SELECT COUNT(DISTINCT)