Thread: Re: [COMMITTERS] pgsql: Fix IS NULL and IS NOT NULL tests on row-valued

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/

Teodor Sigaev <teodor@sigaev.ru> writes:
> 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."

Wups, I missed that part of the docs, will fix.  Thanks.

            regards, tom lane