comparing nulls

From: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: comparing nulls
Date: 2004-01-20 13:43:12
Message-ID: 04012019131206.01434@thenilgiris.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jodi Kanter 2004-01-20 13:44:34 Re: Database diagram
Previous Message Gregory S. Williamson 2004-01-20 07:35:56 Re: Database diagram