Re: impossible to update rows specifying columns with NULL

Поиск
Список
Период
Сортировка
От Guillaume Cottenceau
Тема Re: impossible to update rows specifying columns with NULL
Дата
Msg-id 877jkrxxoa.fsf@meuh.mnc.ch
обсуждение исходный текст
Ответ на Re: impossible to update rows specifying columns with NULL  (Markus Schaber <schabios@logi-track.com>)
Ответы Re: impossible to update rows specifying columns with NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Stéphane RIFF
Дата:
Сообщение: Re: [SPAM] - Re: Connection pool problem - Found word(s) list
Следующее
От: Tom Lane
Дата:
Сообщение: Re: impossible to update rows specifying columns with NULL