Inaccurate results
От
Chad Thompson
Тема
Inaccurate results
Дата
Msg-id
022201c2ced9$d599b280$32021aac@chad
Список
Дерево обсуждения
Inaccurate results "Chad Thompson" <chad@weblinkservices.com>
Re: Inaccurate results greg@turnstep.com
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(*) > 250000and 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
В списке pgsql-novice по дате отправления
