Re: [ADMIN] <empty string> Vs NULL

[Geoff Winkless <pgsqladmin@xxxxxxxx>]

On 9 February 2015 at 11:22, sridhar bamandlapally <sridhar.bn1@xxxxxxxxx> wrote:

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

​

The Right Thing to do is to fix your application, and don't use broken DBMSes: NULL should not denote anything except "this value is not set". If you count an empty string as null, how do you represent the empty string?

Oracle's own documentation suggests that developers should not rely on this behaviour since it may change in the future.

So Do The Right Thing now, and you won't get bitten later.

Geoff​