I just ran this query on my 7.3 DB through pgAdminII
select count(distinct(l.full_phone),tz.state
from lists l join timezone tz on l.area_code = tz.area_codegroup by tz.statehaving
count(*) > 250000
and got these results
count state
351222 AZ
707618 CA
406669 FL
469797 GA
205115 MD ***
1008549 TX
199121 UT ***
I also tried
having count(*) > '250000',
thinking it might have been a type conversion error.
Why would these ( *** ) have showed up in the list?
Thanks
Chad