Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85])
	by hub.org (8.10.1/8.10.1) with ESMTP id e8PInfN80361
	for <pgsql-sql@postgresql.org>; Mon, 25 Sep 2000 14:49:41 -0400 (EDT)
Received: from ipinc.com (jliang.ipinc.com [199.245.188.130])
	by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id LAA30758;
	Mon, 25 Sep 2000 11:49:30 -0700 (PDT)
	(envelope-from jliang@ipinc.com)
Message-ID: <39CF9D5C.B52EF411@ipinc.com>
Date: Mon, 25 Sep 2000 11:45:49 -0700
From: Jie Liang <jliang@ipinc.com>
Organization: ipinc.com
X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386)
X-Accept-Language: en
MIME-Version: 1.0
To: Jeff MacDonald <jeff@pgsql.com>
CC: pgsql-sql@postgresql.org
Subject: Re: select
References: <Pine.BSF.4.21.0009231436490.53901-100000@rage.hub.org>
Content-Type: multipart/alternative;
	boundary="------------827BDC07512004740205492C"
X-Archive-Number: 200009/207


--------------827BDC07512004740205492C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi, there,

only possible is null, so select blah from tableblah where field is
null;

Jeff MacDonald wrote:

> how would i select all rows where a boolean value is neither
> t nor f.. ?
>
> ie if someone inserted without setting the boolean tag.
>
> Jeff MacDonald,
>
> -----------------------------------------------------
> PostgreSQL Inc          | Hub.Org Networking Services
> jeff@pgsql.com          | jeff@hub.org
> www.pgsql.com           | www.hub.org
> 1-902-542-0713          | 1-902-542-3657
> -----------------------------------------------------
> Fascimile : 1 902 542 5386
> IRC Nick  : bignose

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com



--------------827BDC07512004740205492C
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi, there,
<p>only possible is null, so select blah from tableblah where field is
null;
<p>Jeff MacDonald wrote:
<blockquote TYPE=CITE>how would i select all rows where a boolean value
is neither
<br>t nor f.. ?
<p>ie if someone inserted without setting the boolean tag.
<p>Jeff MacDonald,
<p>-----------------------------------------------------
<br>PostgreSQL Inc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| Hub.Org Networking Services
<br>jeff@pgsql.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| jeff@hub.org
<br>www.pgsql.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| www.hub.org
<br>1-902-542-0713&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| 1-902-542-3657
<br>-----------------------------------------------------
<br>Fascimile : 1 902 542 5386
<br>IRC Nick&nbsp; : bignose</blockquote>

<pre>--&nbsp;
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com</pre>
&nbsp;</html>

--------------827BDC07512004740205492C--