testing for null value in integer field? - Mailing list pgsql-sql

How does one check for an unset value in an integer field?

I've tried such things as:

select ..... where intnumber = ''
select ...... where intnumber =  ?
select .....  where intnumber = NULL

Thanks.

-- 
Until later, Geoffrey    esoteric@3times25.net

Building secure systems inspite of Microsoft



pgsql-sql by date:

Previous
From: "Matt Van Mater"
Date:
Subject: how to preserve \n in select statement
Next
From: Wei Weng
Date:
Subject: Re: testing for null value in integer field?