I am attaching an output with this mail. I am sure that I am not inserting
'' for jobcomments in any case.
----- Original Message -----
From: "Jean-Christian Imbeault" <jc(at)mega-bucks(dot)co(dot)jp>
To: "shreedhar" <shreedhar(at)lucidindia(dot)net>
Cc: "Postgre General" <pgsql-general(at)postgresql(dot)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.
> Jean-Christian Imbeault
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
Description: text/html (6.1 KB)
In response to
pgsql-general by date
|Next:||From: Jean-Christian Imbeault||Date: 2003-05-27 08:59:54|
|Subject: Re: Query Which is not supposted to list NULLS is listing|
|Previous:||From: Darko Prenosil||Date: 2003-05-27 07:52:37|
|Subject: Re: PostgreSQL 7.3.1 on WinXP|