| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | sridhar bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] <empty string> Vs NULL |
| Date: | 2015-02-10 04:50:42 |
| Message-ID: | 7903E12E-1791-45C6-80F4-D7907D3B1B08@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
On Feb 9, 2015, at 8:53 PM, sridhar bamandlapally <sridhar(dot)bn1(at)gmail(dot)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, which you need to fix.
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G Johnston | 2015-02-10 05:02:37 | Re: [PERFORM] <empty string> Vs NULL |
| Previous Message | sridhar bamandlapally | 2015-02-10 03:53:35 | Re: [PERFORM] <empty string> Vs NULL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G Johnston | 2015-02-10 05:02:37 | Re: [PERFORM] <empty string> Vs NULL |
| Previous Message | sridhar bamandlapally | 2015-02-10 03:53:35 | Re: [PERFORM] <empty string> Vs NULL |