Received: from www.chip.org (www.chip.org [134.174.22.177])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6NKQaf60389
	for <pgsql-general@postgresql.org>;
	Mon, 23 Jul 2001 16:26:36 -0400 (EDT)
	(envelope-from aturchin@chip.org)
Received: from chip.org ([134.174.23.191])
	by www.chip.org (8.11.0/8.11.0) with ESMTP id f6NKQPV19913;
	Mon, 23 Jul 2001 16:26:25 -0400
Message-ID: <3B5C88B5.73D549AE@chip.org>
Date: Mon, 23 Jul 2001 16:27:34 -0400
From: Alexander Turchin <aturchin@chip.org>
Organization: Children's Hospital Informatics Program
X-Mailer: Mozilla 4.77 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
To: wsheldah@lexmark.com,
	PostgreSQL Mailing List <pgsql-general@postgresql.org>
Subject: Re: COUNTs don't add up
References: <200107232013.QAA08047@interlock2.lexmark.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200107/853
X-Sequence-Number: 12974

Yes, that turns out to be exactly the case - should have thought of it myself (of
course :).

Thanks!

Alex

wsheldah@lexmark.com wrote:

> Could species2 be null?  If so, I don't think those rows would appear when you
> test for <> 'somevalue'.
>
> Alexander Turchin <aturchin%chip.org@interlock.lexmark.com> on 07/23/2001
> 03:32:04 PM