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

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.tatsuhito@oss.ntt.co.jp