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

2006-09-29 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> 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.

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

2006-09-29 Thread Teodor Sigaev
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 N