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

quering NULL values

From: "Luis Silva" <lfs12(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: quering NULL values
Date: 2006-01-30 15:41:10
Message-ID: BAY18-F216D1BDE006E99E0D49E27B5090@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-novice
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



In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-01-30 15:45:32
Subject: Re: Help, 400 million rows, query slow, I stopped after 5 days
Previous:From: OlegDate: 2006-01-30 15:32:04
Subject: Re: wrong objects order using pg_dump

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