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

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>
Subject: Re: Query Which is not supposted to list NULLS is listing
Date: 2003-05-27 07:45:32
Message-ID: 3ED3179C.50207@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darko Prenosil 2003-05-27 07:52:37 Re: PostgreSQL 7.3.1 on WinXP
Previous Message Együd Csaba 2003-05-27 07:35:38 Re: PostgreSQL 7.3.1 on WinXP