Re: BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).

Hi.

Tom Lane wrote:
>> I think following fix is related..
>> http://archives.postgresql.org/pgsql-committers/2006-09/msg00439.php
>
> Yup, it is. Why are you reporting this?

Document(for 8.1.11) said "A row value is considered not null if it has at
least one field that is not null. ".
http://www.postgresql.org/docs/8.1/static/functions-comparisons.html#AEN13425

But "IS NOT NULL" action seemed that it also evaluate the row is not null
if the row has no field that is not null in such case.

I didn't know the action is valid or invalid ..

So I reported this.

Best regards.
--
NTT OSS Center
Tatsuhito Kasahara

kasahara(dot)tatsuhito(at)oss(dot)ntt(dot)co(dot)jp