Re: testing for null value in integer field?

From: CoL <col(at)mportal(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: testing for null value in integer field?
Date: 2003-12-19 16:08:36
Message-ID: brv7p0$7mn$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

try: column is null, as manual shows.

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.

C.

In response to

Browse pgsql-sql by date

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