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

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
>