| From: | sridhar bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | <empty string> Vs NULL |
| Date: | 2015-02-09 11:22:54 |
| Message-ID: | CAGuFTBWoL76nZ-DJqjX4aTyR0i5zJT+1KOFpe0-VTFB3y3DPtw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Hi All
We are testing our Oracle compatible business applications on PostgreSQL
database,
the issue we are facing is <empty string> Vs NULL
In Oracle '' (<empty string>) and NULL are treated as NULL
but, in PostgreSQL '' <empty string> not treated as NULL
I need some *implicit* way in PostgreSQL where ''<empty string> can be
treated as NULL
Please,
Thanks
Sridhar BN
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2015-02-09 11:53:16 | Re: [PERFORM] <empty string> Vs NULL |
| Previous Message | Luis Antonio Dias de Sá Junior | 2015-02-09 10:59:34 | Re: pg_createcluster failing on Trusty |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2015-02-09 11:53:16 | Re: [PERFORM] <empty string> Vs NULL |
| Previous Message | Belal Al-Hamed | 2015-02-08 10:08:30 | Re: Copy command Faster than original select |