X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BE6F99FB1B9 for ; Tue, 6 Jun 2006 14:36:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32479-10 for ; Tue, 6 Jun 2006 14:36:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31815.mail.mud.yahoo.com (web31815.mail.mud.yahoo.com [68.142.206.168]) by postgresql.org (Postfix) with SMTP id 41C659FA13E for ; Tue, 6 Jun 2006 14:36:30 -0300 (ADT) Received: (qmail 17136 invoked by uid 60001); 6 Jun 2006 17:36:28 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=HcvNrrIC5uoSsTOte9b9IcHJt26fiBqvCJtn41DlYqWtjkCb/QiXR7d1OJq1Dmuje5akZHgZP1mL6f2SkVwV2TNphMEpCwp2rW6sCB81Da5m7zzcswMxLcjJ7RIgJqr/mJzGWoBMiEH3J0vMJ+9t7Abz2H3Dja/NRy6NpE7hhps= ; Message-ID: <20060606173628.17134.qmail@web31815.mail.mud.yahoo.com> Received: from [63.203.180.122] by web31815.mail.mud.yahoo.com via HTTP; Tue, 06 Jun 2006 10:36:28 PDT Date: Tue, 6 Jun 2006 10:36:28 -0700 (PDT) From: Richard Broersma Jr Subject: Re: How To Exclude True Values To: operationsengineer1@yahoo.com, "pgsql-sql@postgresql.org" In-Reply-To: <20060606170726.64064.qmail@web33313.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/69 X-Sequence-Number: 25305 > inspect_id, inspect_result_id, inspect_result_pass, > inspect_result_timestamp > 3, 5, f, 2006-06-05 05:00:00 > 3, 6, t, 2006-06-05 06:00:00 > 4, 7, f, 2006-06-05 07:00:00 > *4, 8, f, 2006-06-05 08:00:00* > the query linked in this post will return 3 lines... > > 1, 2, f > 3, 5, f > *4, 8, f* -- the only one i really want