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@cat-it.co.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