Re: Query Which is not supposted to list NULLS is listing
От | shreedhar |
---|---|
Тема | Re: Query Which is not supposted to list NULLS is listing |
Дата | |
Msg-id | 00de01c3242c$1c646b90$1201a8c0@a4005 обсуждение исходный текст |
Ответ на | Query Which is not supposted to list NULLS is listing NULLS also ("shreedhar" <shreedhar@lucidindia.net>) |
Ответы |
Re: Query Which is not supposted to list NULLS is listing
Re: Query Which is not supposted to list NULLS is listing |
Список | pgsql-general |
Hello, I am attaching an output with this mail. I am sure that I am not inserting '' for jobcomments in any case. Sreedhar ----- Original Message ----- From: "Jean-Christian Imbeault" <jc@mega-bucks.co.jp> To: "shreedhar" <shreedhar@lucidindia.net> Cc: "Postgre General" <pgsql-general@postgresql.org> Sent: Tuesday, May 27, 2003 1:15 PM Subject: Re: [GENERAL] Query Which is not supposted to list NULLS is listing > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
Вложения
В списке pgsql-general по дате отправления: