Inaccurate results

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Inaccurate results
Date: 2003-02-07 18:50:49
Message-ID: 022201c2ced9$d599b280$32021aac@chad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Chad Thompson 2003-02-07 19:11:41 Re:
Previous Message Daniel Schuchardt 2003-02-07 16:52:34 Re: "function has no parameter $1" - help.