Re: [PERFORM] Vs NULL

Поиск
Список
Период
Сортировка
От Nikolas Everett
Тема Re: [PERFORM] Vs NULL
Дата
Msg-id CAPmjWd0AhX7Hjpu6FAquNMkTO5Pg4kwZ659HScHQh4OLgLog4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Vs NULL  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [PERFORM] Vs NULL
Следующее
От: Marc Mamin
Дата:
Сообщение: Re: [PERFORM] Vs NULL