IS NULL seems to return false, even when parameter is NULL

Поиск
Список
Период
Сортировка
Искать
От
Lucazeo
Тема
IS NULL seems to return false, even when parameter is NULL
Дата
Msg-id
2411a015-e265-45e5-87b5-09ddbd2ae323@k30g2000hse.googlegroups.com
Список
Дерево обсуждения
IS NULL seems to return false, even when parameter is NULL Lucazeo <lucazeo@katamail.com>
Re: IS NULL seems to return false, even when parameter is NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: IS NULL seems to return false, even when parameter is NULL "Andrus" <kobruleht2@hot.ee>
Re: IS NULL seems to return false, even when parameter is NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: IS NULL seems to return false, even when parameter is NULL Richard Huxton <dev@archonet.com>
Re: IS NULL seems to return false, even when parameter is NULL "Andrus" <kobruleht2@hot.ee>
I have a strange problem with the following condition in a SELECT:
AND (("TableData" = "inDate") OR ("inDate" IS NULL))

it works perfectly when the input date in the function (inDate) matchs
a date in the table, but it does not work when the parameter inDate is
NULL.
I recall the function with pgadmin writing NULL as paramater.
It seems that ("inDate" IS NULL) never returns true, even when the
parameter is null...
What's wrong?

Lucazeo
В списке pgsql-general по дате отправления
От: Ivan Sergio Borgonovo
Дата:
Сообщение: parser: tokens in tsearch2
От: Tom Lane
Дата:
FAQ