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.
On Mon, 22 Feb 1999, Oleg Broytmann wrote:
> 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 Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)net
> Programmers don't die, they just GOSUB without RETURN.
In response to
pgsql-hackers by date
|Next:||From: Tatsuo Ishii||Date: 1999-02-22 14:09:08|
|Subject: Re: [HACKERS] inet data type regression test fails |
|Previous:||From: jose' soares||Date: 1999-02-22 13:44:34|
|Subject: Re: [HACKERS] lower() broken?|