Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).
Date
Msg-id 1869.1207060467@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).  ("Tatsuhito Kasahara" <kasahara.tatsuhito@oss.ntt.co.jp>)
Responses Re: BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).  (Tatsuhito Kasahara <kasahara.tatsuhito@oss.ntt.co.jp>)
List pgsql-bugs
Tree view 
"Tatsuhito Kasahara" <kasahara.tatsuhito@oss.ntt.co.jp> writes:
> PostgreSQL version: 8.1.11
> Description:        "IS NOT NULL (IS NULL)" return wrong answer even where
> all fields are NULL(or NOT NULL).

> I think following fix is related..
> http://archives.postgresql.org/pgsql-committers/2006-09/msg00439.php

Yup, it is.  Why are you reporting this?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Pavel Alexei"
Date:
Subject: BUG #4081: Running Postgres as Windows service vs regular applications
Next
From: "MARCO A GONZALEZ"
Date:
Subject: BUG #4082: Fatal error, close server