COUNT DISTINCT - Mailing list pgsql-general

From Eric Jain
Subject COUNT DISTINCT
Date
Msg-id NCBBJFHBEGOIAHBCBNCLMEEKCJAA.jain@gmx.net
Whole thread Raw
List pgsql-general
SELECT COUNT(DISTINCT url, id) FROM log;
ERROR:  Aggregate functions may only have one parameter

SELECT COUNT(DISTINCT ON (url, id)) FROM log;
ERROR:  parser: parse error at or near "on"

Any ideas how do I get this done properly?


--
Eric Jain


pgsql-general by date:

Previous
From: Richard Harvey Chapman
Date:
Subject: Re: psql \i --UPDATE
Next
From: Andrew McMillan
Date:
Subject: Re: COUNT DISTINCT