Re: impossible to update rows specifying columns with NULL

Markus Schaber <schabios 'at' logi-track.com> writes:

> Hi, Guillaume,
> Hi, Dave,
>
> Dave Cramer schrieb:
> > Well, if you are really intent on using this you can set
> > transform_null_equals=true in postgresql.conf
>
> You don't have to do this globally, you can also issue
>    set transform_null_equals to true;
> as statement so this setting is only for your connection.

Ok thanks.

In the doc pointed by Oliver I can read that this NULL != NULL
behaviour is per SQL standard, so I'm unsure if I should go the
way of forcing the non standard behaviour..

--
Guillaume Cottenceau