Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 520899FB3AC for ; Thu, 8 Feb 2007 15:31:01 -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 38258-04-4 for ; Thu, 8 Feb 2007 15:30:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp109.plus.mail.re2.yahoo.com (smtp109.plus.mail.re2.yahoo.com [206.190.53.34]) by postgresql.org (Postfix) with SMTP id BF3509FB35A for ; Thu, 8 Feb 2007 15:30:50 -0400 (AST) Received: (qmail 89434 invoked from network); 8 Feb 2007 19:30:48 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=Yahoo.com; h=Received:X-YMail-OSG:Received:Message-ID:Date:From:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=p0NolekG0tHD3arGweHKJsCm8ryNrklO9YQV55fBRT+Zbfmdfq4J80thkrdZRuYedmdSiz9ov2pzohOS7qJM6C9pVN44MPUVDLOgdfyNToElKGt/YpcqE1xCjvp3VgmDQiUmVRwaiRznoQLJ5XPwBvoH7DnP1hHnsZRdQ5KUvmo= ; Received: from unknown (HELO jupiter.black-lion.info) (janwieck@71.230.165.92 with login) by smtp109.plus.mail.re2.yahoo.com with SMTP; 8 Feb 2007 19:30:48 -0000 X-YMail-OSG: DCT.lAUVM1lVgnXi6lGe3_utd9CQVYXUhdpStNbkxtWkLUTZDyahzJDyDNwH6YE7npxoGqHzc7MJKlcwy0qri4irYP_Pkslpd8EyajzoF1JIkEj3qhAVgyKS6UNZ40S71nmx0VhRVe6QACs- Received: from [172.21.8.23] (vgateway.libertyrms.info [207.219.45.62]) (authenticated bits=0) by jupiter.black-lion.info (8.12.10/8.12.9) with ESMTP id l18JUjIB019294; Thu, 8 Feb 2007 14:30:46 -0500 (EST) (envelope-from JanWieck@Yahoo.com) Message-ID: <45CB7A5F.2060501@Yahoo.com> Date: Thu, 08 Feb 2007 14:30:39 -0500 From: Jan Wieck User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Jamie A Lawrence CC: Andrew Sullivan , pgsql-sql@postgresql.org Subject: Re: Differentiate Between Zero-Length String and NULLColumn Values 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> <9B53782A-CDF7-4117-9236-62D4926F7835@clueinc.net> In-Reply-To: <9B53782A-CDF7-4117-9236-62D4926F7835@clueinc.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.993 tagged_above=0 required=5 tests=AWL, BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/104 X-Sequence-Number: 27438 On 1/30/2007 3:17 PM, Jamie A Lawrence wrote: > 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 It is well known that Oracle's handling of zero length strings violates all ANSI SQL Standards, so what exactly is your point? Jan > > SQL> select * from dual where '' IS NULL; > > D > - > X > > SQL> select * from dual where '' = NULL; > > no rows selected > > > -j > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #