Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued
Дата
Msg-id 451D275E.1000100@sigaev.ru
обсуждение исходный текст
Ответ на pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to  (tgl@postgresql.org (Tom Lane))
Ответы Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
Дерево обсуждения 
9.17.5. Row-wise Comparison
"These constructs test a row value for null or not null. A row value is
considered not null if it has at least one field that is not null."

I suppose, it should be changed too.

Tom Lane wrote:
> the SQL spec, viz IS NULL is true if all the row's fields are null, IS NOT
> NULL is true if all the row's fields are not null.  The former coding got
--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

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

Предыдущее
От: markir@pgfoundry.org (User Markir)
Дата:
Сообщение: bizgres - bizgres: Fix big whereby cursors declared WITH HOLD would have
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to