Postgres Pro
Downloads
Home   >   mailing lists

quering NULL values - Mailing list pgsql-novice

From Luis Silva
Subject quering NULL values
Date
Msg-id BAY18-F216D1BDE006E99E0D49E27B5090@phx.gbl
Whole thread Raw
In response to problem with returning values from pl/pgsql  ("Luis Silva" <lfs12@hotmail.com>)
Responses Re: quering NULL values
List pgsql-novice
Tree view 
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@ptinovacao.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

pgsql-novice by date:

Previous
From: Oleg
Date:
Subject: Re: wrong objects order using pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Help, 400 million rows, query slow, I stopped after 5 days