X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 105CDD1C931 for ; Thu, 24 Jul 2003 23:31:32 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 79580-10 for ; Thu, 24 Jul 2003 20:30:49 -0300 (ADT) Received: from wildbrain.com (unknown [64.1.15.36]) by svr1.postgresql.org (Postfix) with ESMTP id 0BC73D1C94E for ; Thu, 24 Jul 2003 20:31:30 -0300 (ADT) Received: from underdog.wildbrain.com.wildbrain.com (IDENT:danimal@underdog.wildbrain.com [10.20.2.33]) by wildbrain.com (8.12.9/8.12.9) with ESMTP id h6ONVUxr019381; Thu, 24 Jul 2003 16:31:30 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16160.27713.892311.733277@underdog.wildbrain.com> Date: Thu, 24 Jul 2003 16:31:13 -0700 To: Rod Taylor Cc: pgsql-sql@postgresql.org Subject: Re: silly NULL question In-Reply-To: <1059089115.90090.8.camel@jester> References: <16160.26749.931319.656882@underdog.wildbrain.com> <1059089115.90090.8.camel@jester> X-Mailer: VM 7.14 under 21.4 (patch 12) "Portable Code" XEmacs Lucid From: Dan Weeks Organization: Wild Brain, Inc. Precedence: special-delivery X-Face: ; YwbDtIZ+}[w10%qP:*:Y,B1F{{mUG&T>>>> "RT" == "Rod Taylor" : RT> NULL is similar to UNKNOWN. RT> RT> So, NULL = NULL is the similar to UNKNOWN = UNKNOWN. Since you don't RT> know it, how can you tell if they're equal or not? RT> RT> Syntax you're looking for is: AND parent_id IS NULL ah, of course. Thanks Rod. RT> If you really really really need = NULL (due to some MS product which RT> ignores SQL standards -- say MS Access) there is a toggle in the RT> postgresql.conf file to allow automated conversion of = NULL to IS NULL RT> within the server. ah ha! the culprit. I see this was default through 7.1. Thanks again for accurate and quick reply. -dan