Re: Null comparisons and the transform_null_equals run-time parameter

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Null comparisons and the transform_null_equals run-time parameter
Дата
Msg-id 4405.1275745274@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Null comparisons and the transform_null_equals run-time parameter  ("Ken Winter" <ken@sunward.org>)
Ответы Re: Null comparisons and the transform_null_equals run-time parameter
Список pgsql-general
"Ken Winter" <ken@sunward.org> writes:
> When the run-time parameter transform_null_equals is on, shouldn't two
> variables with NULL values evaluate as equal?

No.  That setting does not change the runtime behavior of comparison.
The only thing it does is change the literal syntax "something = NULL"
to "something IS NULL".

            regards, tom lane

В списке pgsql-general по дате отправления: