<empty string> Vs NULL

[sridhar bamandlapally <sridhar.bn1@xxxxxxxxx>]

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