Re: [HACKERS] SELECT COUNT(DISTINCT)

I was in need of that exact feature awhile back.  As far as I can tell it
isn't supported.  I ended up using a complicated NOT EXISTS query instead.
I've been meaning to hack this, but I haven't gotten a chance.  

-Andy


On Mon, 22 Feb 1999, Oleg Broytmann wrote:

> 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 just GOSUB without RETURN.
> 
> 
>