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(at)earthling(dot)net
> Programmers don't die, they just GOSUB without RETURN.
>
>
>