Re: Query Which is not supposted to list NULLS is listing

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема Re: Query Which is not supposted to list NULLS is listing
Дата
Msg-id 3ED3179C.50207@mega-bucks.co.jp
обсуждение исходный текст
Ответ на Query Which is not supposted to list NULLS is listing NULLS also  ("shreedhar" <shreedhar@lucidindia.net>)
Список pgsql-general
Дерево обсуждения 
shreedhar wrote:
>
> SELECT jassignedid, JobComments FROM tblJobIncharge WHERE JobComments IS
> NOT NULL AND projectid >= 50 AND projectid <= 100
>
> Which is not supposed to list NULLS  is listing NULLS also.

I can't see anything wrong with your query. Can you give some output to
show what the problem is? The results should not contain and row where
JobComments IS NULL AFAICT.

Maybe I missed something in your question so please give some output.

HTH,

--

Jean-Christian Imbeault

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

Предыдущее
От: Darko Prenosil (by way of Darko Prenosil
Дата:
Сообщение: Re: PostgreSQL 7.3.1 on WinXP
Следующее
От: "shreedhar"
Дата:
Сообщение: Re: Query Which is not supposted to list NULLS is listing