comparing nulls - Mailing list pgsql-sql

From Kenneth Gonsalves
Subject comparing nulls
Date
Msg-id 04012019131206.01434@thenilgiris.com
Whole thread Raw
Responses Re: comparing nulls
Re: comparing nulls
Re: comparing nulls
List pgsql-sql
in postgres7.1 i had a table where an integer field could be null. There was 
no default value. a select statement like so:
'select * from table where field = null' 
would give all the rows where that field had no value.
on porting to 7.3.2, this doesnt work. How to do this?
-- 
regards
kg

http://www.ootygolfclub.org
poor man's tally: http://avsap.sourceforge.net


pgsql-sql by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: Database diagram
Next
From: Chris Bowlby
Date:
Subject: Re: comparing nulls