Re: [GENERAL] Any ideas why this doesn't work or how to rewrite it?

[Bob Dusek]

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