Vs NULL - Mailing list pgsql-performance

From sridhar bamandlapally
Subject Vs NULL
Date
Msg-id CAGuFTBWoL76nZ-DJqjX4aTyR0i5zJT+1KOFpe0-VTFB3y3DPtw@mail.gmail.com
Whole thread Raw
Responses Re: Vs NULL
Re: [ADMIN] Vs NULL
List 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

pgsql-performance by date:

Previous
From: Belal Al-Hamed
Date:
Subject: Re: Copy command Faster than original select
Next
From: Pavel Stehule
Date:
Subject: Re: Vs NULL