Re: [PERFORM] Vs NULL
От | Pavel Stehule |
---|---|
Тема | Re: [PERFORM] |
Дата | |
Msg-id | CAFj8pRCg0qbpwGBwG2fqzDo=JRkWROVRpoOuPsNUtOTdtOGUqA@mail.gmail.com обсуждение исходный текст |
Ответ на |
|
Ответы |
Re: [PERFORM] Re: [PERFORM] |
Список | pgsql-admin |
Hi
2015-02-09 12:22 GMT+01:00 sridhar bamandlapally <sridhar.bn1@gmail.com>:
Hi AllWe are testing our Oracle compatible business applications on PostgreSQL database,the issue we are facing is <empty string> Vs NULLIn Oracle '' (<empty string>) and NULL are treated as NULLbut, in PostgreSQL '' <empty string> not treated as NULLI 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
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,ThanksSridhar BN
В списке pgsql-admin по дате отправления: