Postgres Pro
Downloads
Home   >   mailing lists

Re: WHERE =NULL malfunction in release 7.2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: WHERE =NULL malfunction in release 7.2
Date
Msg-id 20838.1024679756@sss.pgh.pa.us
Whole thread Raw
In response to WHERE =NULL malfunction in release 7.2  (Ingo Ciechowski <ciechowski@cis-computer.com>)
List pgsql-bugs
Tree view 
Ingo Ciechowski <ciechowski@cis-computer.com> writes:
> i++=# select * from uri where freigegeben=NULL;

This is not a bug; the 7.1.* behavior is the bug.

But see transform_null_equals if your application logic depends on
the old non-spec-compliant behavior.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: WHERE =NULL malfunction in release 7.2
Next
From: Josemar Dias Ferreira
Date:
Subject: INITDB hanging on Win2000/CygWin (PGSQL 7.2.1).