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

Re: quering NULL values

From: Charley Tiggs <ctiggs(at)xpressdocs(dot)com>
To: Luis Silva <lfs12(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: quering NULL values
Date: 2006-01-30 15:47:10
Message-ID: 43DE34FE.6040609@xpressdocs.com (view raw or flat)
Thread:
Lists: pgsql-novice
Luis Silva wrote:
> I there I'm having a problem.
> 
> I'm doing this SQL query
> 
> select count(*) from public_identif INNER JOIN ifc ON 
> ifc.spid=public_identif.spid where (ifc.profilepartindicator='' OR 
> ifc.profilepartindicator='UNREGISTERED') AND 
> public_identif.identity='sip:joao(at)ptinovacao(dot)pt'
> 
> 
> ifc.profilepartindicator=''  can be a NULL value that is why i'm doing 
> this, but it's not working. I tried ifc.profilepartindicator=NULL but i 
> get nothing again. Can you help please?? Tks a lot


change your query as follows:

select count(*) from public_identif INNER JOIN ifc ON 
ifc.spid=public_identif.spid where (ifc.profilepartindicator='' OR 
ifc.profilepartindicator IS NULL OR 
ifc.profilepartindicator='UNREGISTERED') AND 
public_identif.identity='sip:joao(at)ptinovacao(dot)pt'

Note the addition of "ifc.profilepartindicator IS NULL" within the 
parentheses.

Charley

In response to

Responses

pgsql-novice by date

Next:From: Christian HofmannDate: 2006-01-30 15:54:22
Subject: Re: Help, 400 million rows, query slow, I stopped after 5 days
Previous:From: Tom LaneDate: 2006-01-30 15:45:32
Subject: Re: Help, 400 million rows, query slow, I stopped after 5 days

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