> > SELECT count(DISTINCT url) FROM log; does work. The problem is to
> > extend the DISTINCT over several fields...
>
> Right - I should have looked closer shouldn't I :-)
>
> What about...
>
> advert=# select count( distinct ( (text(advert_no) ||
> text(pool_id)) ) )
> from redirect;
Good idea! Unfortunatly this ignores all rows with NULL in either of
the fields...
I guess if I'm a bit patient one day pgsql will allow for something
like:
SELECT COUNT(SELECT DISTINCT url,id FROM log) FROM log;
--
Eric Jain