RE: COUNT DISTINCT

> SELECT count( DISTINCT(url,id) ) FROM log;
>
> Seems to work for me...

Thanks... however:

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

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"

...


> 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)

SELECT count(DISTINCT url) FROM log; does work. The problem is to
extend the DISTINCT over several fields...


--
Eric Jain