Postgres Pro
Downloads
Home   >   mailing lists

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

From Geoffrey
Subject testing for null value in integer field?
Date
Msg-id 3FE32231.5030207@3times25.net
Whole thread Raw
Responses Re: testing for null value in integer field?  (Wei Weng <wweng@kencast.com>)
Re: testing for null value in integer field?  (Guy Fraser <guy@incentre.net>)
Re: testing for null value in integer field?  (CoL <col@mportal.hu>)
List pgsql-sql
Tree view 
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?