Home > mailing lists

Inaccurate results - Mailing list pgsql-novice

From	Chad Thompson
Subject	Inaccurate results
Date	February 7, 2003 16:53:36
Msg-id	022201c2ced9$d599b280$32021aac@chad Whole thread Raw
Responses	Re: Inaccurate results
List	pgsql-novice

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_code

group by tz.state

having

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

From: greg@turnstep.com
Date: 07 February 2003, 13:53:19
Subject: Re:

From: "Chad Thompson"
Date: 07 February 2003, 17:14:27
Subject: Re: