| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Hofmann | 2006-01-30 15:54:22 | Re: Help, 400 million rows, query slow, I stopped after 5 days |
| Previous Message | Tom Lane | 2006-01-30 15:45:32 | Re: Help, 400 million rows, query slow, I stopped after 5 days |