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