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

From Guillaume Cottenceau
Subject Re: impossible to update rows specifying columns with NULL
Date
Msg-id 877jkrxxoa.fsf@meuh.mnc.ch
Whole thread Raw
In response to Re: impossible to update rows specifying columns with NULL  (Markus Schaber <schabios@logi-track.com>)
Responses Re: impossible to update rows specifying columns with NULL
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Stéphane RIFF
Date:
Subject: Re: [SPAM] - Re: Connection pool problem - Found word(s) list
Next
From: Tom Lane
Date:
Subject: Re: impossible to update rows specifying columns with NULL