> 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