Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 81D5D9FB3BD for ; Tue, 30 Jan 2007 16:39:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 65076-10 for ; Tue, 30 Jan 2007 16:39:27 -0400 (AST) X-Greylist: delayed 00:21:22.440834 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id F3C869FB2ED for ; Tue, 30 Jan 2007 16:39:27 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from frankenbride.clueinc.net (xd84b4366.ip.e-nt.net [216.75.67.102]) by svr4.postgresql.org (Postfix) with ESMTP id C38AD5AF90B for ; Tue, 30 Jan 2007 20:18:04 +0000 (GMT) Received: from [216.75.67.107] (jal.clueinc.net [216.75.67.107]) by frankenbride.clueinc.net (Postfix) with ESMTP id C549ABB15; Tue, 30 Jan 2007 15:17:57 -0500 (EST) In-Reply-To: <20070130165503.GC32170@phlogiston.dyndns.org> References: <20070130131334.GD31676@phlogiston.dyndns.org> <45BF584F.A3DD.0030.0@indicator.be> <20070130142332.GA31905@phlogiston.dyndns.org> <20070130113834.fa8d09e0.darcy@druid.net> <20070130165503.GC32170@phlogiston.dyndns.org> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <9B53782A-CDF7-4117-9236-62D4926F7835@clueinc.net> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Jamie A Lawrence Subject: Re: Differentiate Between Zero-Length String and NULLColumn Values Date: Tue, 30 Jan 2007 15:17:56 -0500 To: Andrew Sullivan X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/32 X-Sequence-Number: 27366 Just a datapoint: SQL*Plus: Release 10.1.0.3.0 - Production on Tue Jan 30 15:15:49 2007 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select * from dual where '' IS NULL; D - X SQL> select * from dual where '' = NULL; no rows selected -j