Re: COUNT DISTINCT

Eric Jain wrote:
>
> 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?

SELECT count( DISTINCT(url,id) ) FROM log;

Seems to work for me...

Well, actually:
advert=# select count( distinct ( redirect_from ) ) from redirect;
count
-------
1980
(1 row)

rather than:

advert=# select count( redirect_from ) from redirect;
count
-------
4211
(1 row)

Cheers,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267