Re: [PERFORM] Vs NULL - Mailing list pgsql-admin

From Nikolas Everett
Subject Re: [PERFORM] Vs NULL
Date
Msg-id CAPmjWd0AhX7Hjpu6FAquNMkTO5Pg4kwZ659HScHQh4OLgLog4g@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Vs NULL  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-admin

Its been a while since I really worked with Postgres, but could you write a trigger to convert empty string to null on save?  You'd have to carefully apply it everywhere but it'd get you the searching for null finds empty. If that is all you do the you've got it.

Essentially, there isn't a switch for it but you can do it with some mechanisms.

Nik

On Feb 9, 2015 6:54 AM, "Pavel Stehule" <pavel.stehule@gmail.com> wrote:
Hi

2015-02-09 12:22 GMT+01:00 sridhar bamandlapally <sridhar.bn1@gmail.com>:
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

It is not possible in PostgreSQL.  PostgreSQL respects ANSI SQL standard - Oracle not.

Regards

Pavel

p.s. theoretically you can overwrite a type operators to support Oracle behave, but you should not be sure about unexpected negative side effects.

 

Please,

Thanks
Sridhar BN


pgsql-admin by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [PERFORM] Vs NULL
Next
From: Marc Mamin
Date:
Subject: Re: [PERFORM] Vs NULL