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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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