Strange result with select/not null/OR

Поиск
Список
Период
Сортировка
От Fernando Papa
Тема Strange result with select/not null/OR
Дата
Msg-id F1DC5B511E2D1C499E5E20FC6D74160D032DA1BB@exch2000.buehuergo.corp.claxson.com
обсуждение исходный текст
Ответы Re: Strange result with select/not null/OR  (Avi Schwartz <avi@CFFtechnologies.com>)
Список pgsql-general
Hi all!

I get a strange result with this query:

SELECT count(*)
  FROM CONT_CAT
 WHERE id_instal = 2
   and id_cat = 2
   and (sp_link IS NOT NULL OR sp_link <> '')


I have one row with an empty value ('') on sp_link, so, when I execute
the query expect 0 on the result.
I don't know why the result is 1.
If I only put the last part ("sp_link <> ''") everithing goes ok.
But I need to check both conditions, IF is null and IF is empty. And I
can't understand why doesn't work.

Any ideas?

Thanks in advance!


--
Fernando O. Papa
DBA

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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: timestamp
Следующее
От: Jean-Christian Imbeault
Дата:
Сообщение: Re: Strange result with select/not null/OR