Hey there...
> SELECT customer_username, COUNT(customer_username) FROM customerdata GROUP BY customer_username;
>
The above query, in effect, does the same thing that:
SELECT DISTINCT(customer_username) from customerdata
does. In order to get the total number of distinct customer_usernames,
you would still have to count the rows returned (which is easily
enough done with PHP $count = pg_NumRows($query_result)).
My guess is that SELECT DISTINCT might even be a bit quicker...?? (gurus)
>
Bob