why the need for is null?

Поиск
Список
Период
Сортировка
От Baldur Norddahl
Тема why the need for is null?
Дата
Msg-id 1072993535.3ff494ff59605@localhost
обсуждение исходный текст
Ответы Re: why the need for is null?
Re: why the need for is null?
Список pgsql-general
Hi,

How come "X=null" is not the same as "X is null"? I got a few selects with
queries like this:

select * from foo where customer=#customer# or (#customer# is null and customer
is null)

Without the last part, it will not correctly match null customers.

PS. I am using the ibatis framework for java, so the #customer# gets translated
to ? and the whole thing made into a prepared statement.

Thanks,

Baldur

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

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