Re: select * from mytable where myfield=null;

Поиск
Список
Период
Сортировка
От Jeremy Buchmann
Тема Re: select * from mytable where myfield=null;
Дата
Msg-id 3CE155C1.2060602@wellsgaming.com
обсуждение исходный текст
Ответ на Re: select * from mytable where myfield=null;  ("Hoanui Morangie" <hoanui@excite.com>)
Список pgsql-jdbc
Tom Lane wrote:
> "Marin Dimitrov" <marin.dimitrov@sirma.bg> writes:
>
>>don't use NULLs
>
>
> I agree with Marin.  If you think you need x = NULL to act like x IS
> NULL, then you should rethink the way you are using NULL in your data
> design.  You are really swimming against the tide of the way that SQL
> specifies NULL to work.
>
>             regards, tom lane


Has this change affected the behavior of the isnull
operator/keyword/whatever it is...

select * from tablename where foo isnull;

I use that on occasion (in 7.1.2)...did this change in 7.2 also?

--Jeremy



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

Предыдущее
От: Cathal de Brun
Дата:
Сообщение: Re: j2ee compatiable jdbc driver on jdbc.postgresql.org?
Следующее
От: Haug Bürger
Дата:
Сообщение: Re: insert blocking?