Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43435=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YL2mp-0003uy-6z
 for pgsql-admin@arkaria.postgresql.org; Tue, 10 Feb 2015 04:50:59 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43435=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YL2mn-0006XG-Nl
 for pgsql-admin@arkaria.postgresql.org; Tue, 10 Feb 2015 04:50:57 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <scott_ribe@elevated-dev.com>)
 id 1YL2mm-0006X7-Ku
 for pgsql-admin@postgresql.org; Tue, 10 Feb 2015 04:50:56 +0000
Received: from mailout.easymail.ca ([64.68.201.169])
 by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <scott_ribe@elevated-dev.com>)
 id 1YL2me-0004Ed-6X
 for pgsql-admin@postgresql.org; Tue, 10 Feb 2015 04:50:55 +0000
Received: from localhost (localhost [127.0.0.1])
 by mailout.easymail.ca (Postfix) with ESMTP id 8CFA1E234;
 Mon,  9 Feb 2015 23:50:44 -0500 (EST)
X-Virus-Scanned: Debian amavisd-new at mailout.easymail.ca
X-Spam-Flag: NO
X-Spam-Score: -3.986
X-Spam-Level: 
X-Spam-Status: No, score=-3.986 required=5 tests=[ALL_TRUSTED=-1.8,
 AWL=-0.279, BAYES_00=-2.599, DNS_FROM_AHBL_RHSBL=0.692]
Received: from mailout.easymail.ca ([127.0.0.1])
 by localhost (easymail-mailout.easydns.vpn [127.0.0.1]) (amavisd-new,
 port 10024)
 with ESMTP id 3tqWq4RyDU5d; Mon,  9 Feb 2015 23:50:43 -0500 (EST)
Received: from [192.168.2.16] (unknown [8.39.228.5])
 (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by mailout.easymail.ca (Postfix) with ESMTPSA id A78F1E235;
 Mon,  9 Feb 2015 23:50:43 -0500 (EST)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2070.6\))
Subject: Re: [PERFORM] <empty string> Vs NULL
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAGuFTBXaMmPuY8H1pFGvJWA=tUiTM0g92=_a8eHA=ACQmjEikA@mail.gmail.com>
Date: Mon, 9 Feb 2015 21:50:42 -0700
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <7903E12E-1791-45C6-80F4-D7907D3B1B08@elevated-dev.com>
References: 
 <CAGuFTBWoL76nZ-DJqjX4aTyR0i5zJT+1KOFpe0-VTFB3y3DPtw@mail.gmail.com>
 <CAFj8pRCg0qbpwGBwG2fqzDo=JRkWROVRpoOuPsNUtOTdtOGUqA@mail.gmail.com>
 <B6F6FD62F2624C4C9916AC0175D56D8828B5B4AA@jenmbs01.ad.intershop.net>
 <B6F6FD62F2624C4C9916AC0175D56D8828B5B4D1@jenmbs01.ad.intershop.net>
 <CAGuFTBXaMmPuY8H1pFGvJWA=tUiTM0g92=_a8eHA=ACQmjEikA@mail.gmail.com>
To: sridhar bamandlapally <sridhar.bn1@gmail.com>
X-Mailer: Apple Mail (2.2070.6)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Feb 9, 2015, at 8:53 PM, sridhar bamandlapally <sridhar.bn1@gmail.com> w=
rote:
>=20
> the issue is, while DML its empty string and while SELECT its comparing w=
ith NULL

The issue is, empty string is NOT the same as null, and expecting select fo=
r null to match empty strings is a bug, which you need to fix.

--=20
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin