Re: testing for null value in integer field?

From: Guy Fraser <guy(at)incentre(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: testing for null value in integer field?
Date: 2003-12-19 16:16:34
Message-ID: 3FE32462.10708@incentre.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

select ..... where intnumber IS NULL

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.
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Geoffrey 2003-12-19 16:22:21 Re: testing for null value in integer field?
Previous Message Wei Weng 2003-12-19 16:12:24 Re: testing for null value in integer field?