Re: [ADMIN] <empty string> Vs NULL
От
Geoff Winkless
Тема
Re: [ADMIN] <empty string> Vs NULL
Дата
Msg-id
CAEzk6fefR6t0WACGX4-RsvZpwMYH2fsjWiXo2ML5gXoaUyL2+w@mail.gmail.com
Ответ на
<empty string> Vs NULL (sridhar bamandlapally)
Список
Дерево обсуждения
<empty string> Vs NULL sridhar bamandlapally <sridhar.bn1@gmail.com>
Re: [ADMIN] <empty string> Vs NULL Geoff Winkless <pgsqladmin@geoff.dj>
Re: [ADMIN] <empty string> Vs NULL Geoff Winkless <pgsqladmin@geoff.dj>
Re: <empty string> Vs NULL Pavel Stehule <pavel.stehule@gmail.com>
Re: [ADMIN] <empty string> Vs NULL Marc Mamin <M.Mamin@intershop.de>
Re: <empty string> Vs NULL Nikolas Everett <nik9000@gmail.com>
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
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 по дате отправления
