Re: [ADMIN] Vs NULL

Поиск
Список
Период
Сортировка
От Geoff Winkless
Тема Re: [ADMIN] Vs NULL
Дата
Msg-id CAEzk6fefR6t0WACGX4-RsvZpwMYH2fsjWiXo2ML5gXoaUyL2+w@mail.gmail.com
обсуждение исходный текст
Ответ на Vs NULL  (sridhar bamandlapally <sridhar.bn1@gmail.com>)
Ответы Re: [ADMIN] Vs NULL
Список pgsql-performance
On 9 February 2015 at 11:22, sridhar bamandlapally <sridhar.bn1@gmail.com> wrote:
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


The Right Thing to do is to fix your application, and don't use broken DBMSes: NULL should not denote anything except "this value is not set". If you count an empty string as null, how do you represent the empty string?

Oracle's own documentation suggests that developers should not rely on this behaviour since it may change in the future.

So Do The Right Thing now, and you won't get bitten later.

Geoff​
 

В списке pgsql-performance по дате отправления:

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