Skip site navigation (1) Skip section navigation (2)

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

From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: "Jean-Christian Imbeault" <jc(at)mega-bucks(dot)co(dot)jp>
Cc: "Postgre General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query Which is not supposted to list NULLS is listing
Date: 2003-05-27 08:43:55
Message-ID: 00de01c3242c$1c646b90$1201a8c0@a4005 (view raw or flat)
Thread:
Lists: 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(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.
>
> HTH,
>
> --
>
> 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
>

Attachment: Test.htm
Description: text/html (6.1 KB)

In response to

Responses

pgsql-general by date

Next:From: Jean-Christian ImbeaultDate: 2003-05-27 08:59:54
Subject: Re: Query Which is not supposted to list NULLS is listing
Previous:From: Darko PrenosilDate: 2003-05-27 07:52:37
Subject: Re: PostgreSQL 7.3.1 on WinXP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group