Re: impossible to update rows specifying columns with NULL

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: Markus Schaber <schabios(at)logi-track(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: impossible to update rows specifying columns with NULL
Date: 2005-03-01 14:12:21
Message-ID: 877jkrxxoa.fsf@meuh.mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2005-03-01 18:03:48 Re: impossible to update rows specifying columns with NULL
Previous Message Markus Schaber 2005-03-01 13:51:05 Re: impossible to update rows specifying columns with NULL