Re: [PERFORM] Vs NULL

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [PERFORM] Vs NULL
Дата
Msg-id CAFj8pRCg0qbpwGBwG2fqzDo=JRkWROVRpoOuPsNUtOTdtOGUqA@mail.gmail.com
обсуждение исходный текст
Ответ на Vs NULL  (sridhar bamandlapally <sridhar.bn1@gmail.com>)
Ответы Re: [PERFORM] Vs NULL  (Nikolas Everett <nik9000@gmail.com>)
Re: [PERFORM] Vs NULL  (Marc Mamin <M.Mamin@intershop.de>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: sridhar bamandlapally
Дата:
Сообщение: Vs NULL
Следующее
От: Nikolas Everett
Дата:
Сообщение: Re: [PERFORM] Vs NULL