Re: WHERE =NULL malfunction in release 7.2

On Thu, Jun 20, 2002 at 17:28:31 +0200,
  Ingo Ciechowski <ciechowski@cis-computer.com> wrote:
> Hi,
>
> first of all let me tell all of you that PostgreSQL is among the best
> in OpenSource!
>
> Unfortunaly there's a (hopefully easy to fix) bug in release 7.2 and
> 7.2.1 that was not there in 7.1.3 and caused me to switch back today.
>
>
> Here's the table I'm using (unfortunately I already switched back to
> 7.1.3 and therefore can't verify whether or not this occurs with an
> easier setup):

7.1 had a hack because = NULL worked that way in Microsoft's DB.
You want to use 'IS NULL' to match null values. '= NULL' will always
be 'unknown' (which isn't 'true' so the where clause won't be satisified).