Re: [ADMIN] <empty string> Vs NULL

On 9 February 2015 at 11:22, sridhar bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>
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​