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.


Mon, 22 Feb 1999 16:22:31 +0300 (MSK)
Oleg Broytmann <phd@sun.med.ru>
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.
> 
> 
> 


Mon, 22 Feb 1999 08:46:09 -0500 (EST)
Andy Selle <aselle@earth.mat.net>
Re: [HACKERS] SELECT COUNT(DISTINCT)
>    I am trying to execute query:
> SELECT city_id, COUNT(DISTINCT pos_id)
>    ...
> GROUP BY city_id ;
> It is me who do not understand SQL or postgres does not implement it?

As Andy points out, it is not (yet) implemented. afaik no one is working
on it currently.

                    - Tom

Tue, 23 Feb 1999 03:13:07 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] SELECT COUNT(DISTINCT)