Re: (null) != (null) ?

Todd Vierling wrote:
> (1) SELECT ... FROM table1 a,table2 b WHERE a.fieldname = b.fieldname;
>
> Both "fieldname" definitions are identical (verified with char(2) and
> varchar(100) in particular), and both tables contain a row with a "null" in
> that field. However, the results don't contain the row with the "null"
> value. A quick reproduction:

This is standard SQL behavior. NULL != NULL. Essentially, NULL is an
undefined value. Since it is undefined, it can't be know to be equal to
anything, even another undefined value.

Oracle has the NVL function which can be used to replace nulls with
known values allowing your statement above to work as you expect. I
don't think Postgres has a similar function but you could probably write
your own.

--
Thomas Pfau
pfau(at)maherterminals(dot)com
aka pfau(at)eclipse(dot)net
http://www.eclipse.net/~pfau/