Re: [ADMIN] Vs NULL - Mailing list pgsql-performance

From Geoff Winkless
Subject Re: [ADMIN] Vs NULL
Date
Msg-id CAEzk6fefR6t0WACGX4-RsvZpwMYH2fsjWiXo2ML5gXoaUyL2+w@mail.gmail.com
Whole thread Raw
In response to Vs NULL  (sridhar bamandlapally <sridhar.bn1@gmail.com>)
Responses Re: [ADMIN] Vs NULL
List pgsql-performance
On 9 February 2015 at 11:22, sridhar bamandlapally <sridhar.bn1@gmail.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​
 

pgsql-performance by date:

Previous
From: Marc Mamin
Date:
Subject: Re: [ADMIN] Vs NULL
Next
From: Geoff Winkless
Date:
Subject: Re: [ADMIN] Vs NULL