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

Geoffrey wrote:

> 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.
>
It is actually WHERE intnumber IS NULL. You don't use operator = to 
compare with NULLs, you use IS.

HTH.

Wei