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