X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2285CD1B170 for ; Tue, 29 Jun 2004 14:37:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12275-04 for ; Tue, 29 Jun 2004 17:37:24 +0000 (GMT) Received: from stark.xeocode.com (gsstark.mtl.istop.com [66.11.160.162]) by svr1.postgresql.org (Postfix) with ESMTP id 5EAFFD1B252 for ; Tue, 29 Jun 2004 14:37:23 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1BfMXp-0003h7-00; Tue, 29 Jun 2004 13:37:21 -0400 To: Rich Hall Cc: pgsql-sql@postgresql.org Subject: Re: FW: "=" operator vs. "IS" References: <7A4ADADFC8AFF0478D47F63BEDD57CE33A320C@gpmail.gphq.genpathpharma.com> <40E17C81.3090308@micropat.com> In-Reply-To: <40E17C81.3090308@micropat.com> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 29 Jun 2004 13:37:21 -0400 Message-ID: <87wu1qxo32.fsf@stark.xeocode.com> Lines: 11 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/298 X-Sequence-Number: 18243 Rich Hall writes: > "(anything) = NULL" is always Null, this cannot be what the coder intended. I often have such things in my SQL. Consider what happens when you have SQL constructed dynamically. Or more frequently, consider that many drivers still don't use the new binary placeholder syntax and emulate it by putting the parameters directly into the SQL. -- greg