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.
See http://www.postgresql.org/docs/8.0/static/functions-comparison.html
for details.
-O