> > The x = NULL hack keeps biting people.  Innocent people 
> should not be 
> > exposed to incorrect behaviour because of (supposed) MS Access 
> > breakage. I strongly urge that we do one of the following:
> >
> > 1) Provide a tunable knob to turn this on (cf. KSQO)
> >
> > 2) Confine this to the ODBC driver somehow (which could be done via 
> > #1)
> >
> > Actually, last time we discussed this there was some 
> confusion whether 
> > Access actually had the bug in question.  That might be 
> worth figuring 
> > out.
> >
> 
> A while back I tested Oracle and MSSQL7 for this -- neither 
> support it. See: http://fts.postgresql.org/db/mw/msg.html?mid=1021527
> 
> I just checked MS Access 2000 -- it also returns no records 
> on x = NULL versus the correct answer with x IS NULL, at 
> least for a simple query. IIRC, someone mentioned that the 
> original issue was limited to the use of filtered forms in 
> Access, or something like that. But ISTM, that if neither 
> Oracle nor even MSSQL support the syntax, then PostgreSQL 
> should not either.

MSSQL supports =NULL syntax if you set ANSI_NULLS=OFF (can be set per
connection, and yuo can also specify which is default for a certain
database or installation).
I beleive that ANSI_NULLS=OFF was default in SQL Server <= 6.5, and
ANSI_NULLS=ON are default in >= 7.0.

And yes, if you create a Query with Access, it uses IS NULL / IS NOT
NULL. The issue was with filtered forms only.

//Magnus

Tue, 11 Sep 2001 14:15:20 +0200
"Magnus Hagander" <mha@sollentuna.net>
Re: x = NULL