Re: impossible to update rows specifying columns with NULL value? - Mailing list pgsql-jdbc

Oliver Jowett <oliver 'at' opencloud.com> writes:

> Guillaume Cottenceau wrote:
>
> > The problem is when trying to UPDATE (changing values of other
> > columns): my PreparedStatement uses "... WHERE column = ?" to
> > specify the NULL value for the said column,
>
> You can't do that and get the results you expect. "column = NULL" is
> never true (because "NULL = NULL" is false). You should use IS NULL to
> match a NULL value.

It's a pity. This would be very helpful. With such situation, we
can't use the same prepared-statement to match NULL and non-NULL
values then, or I missed something?

--
Guillaume Cottenceau