Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Vs NULL - Mailing list pgsql-admin

From Scott Ribe
Subject Re: [PERFORM] Vs NULL
Date
Msg-id 7903E12E-1791-45C6-80F4-D7907D3B1B08@elevated-dev.com
Whole thread Raw
In response to Re: [PERFORM] Vs NULL  (sridhar bamandlapally <sridhar.bn1@gmail.com>)
List pgsql-admin
Tree view 
On Feb 9, 2015, at 8:53 PM, sridhar bamandlapally <sridhar.bn1@gmail.com> wrote:
>
> the issue is, while DML its empty string and while SELECT its comparing with NULL

The issue is, empty string is NOT the same as null, and expecting select for null to match empty strings is a bug,
whichyou need to fix. 

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

pgsql-admin by date:

Previous
From: sridhar bamandlapally
Date:
Subject: Re: [PERFORM] Vs NULL
Next
From: David G Johnston
Date:
Subject: Re: [PERFORM] Vs NULL