Re: Intentional, or bug? - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Intentional, or bug?
Date
Msg-id Pine.BSF.4.21.0109161240310.54472-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Intentional, or bug?  (Tod McQuillin <devin@spamcop.net>)
List pgsql-sql
On Mon, 17 Sep 2001, Tod McQuillin wrote:

> On Sun, 16 Sep 2001, Kovacs Baldvin wrote:
> 
> > select NULL = NULL;
> >
> > The answer is: true!!!
> 
> This has got to be a bug.  NULL is not equal to anything (nor is it
> unequal to anything).

This is because of a hack due to a broken MS client that provided
=NULL for IS NULL in some (possibly small) case.  There's a grammar
hack which makes the token sequence = NULL into IS NULL.  There's
been talk about making this optional or ripping it out entirely (yay), 
see past discussions on this topic for more detail.





pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Intentional, or bug?
Next
From: "Josh Berkus"
Date:
Subject: Re: optimizing queries and indexes...