Re: why the need for is null?

"Chris Travers" <chris@travelamericas.com> writes:
> Minor correction to Christopher Browne's post:
> It is currently possible to set PostgreSQL to evaluate x = NULL as x IS
> NULL.

Also, while I'm not totally sure about the behavior of SQL Server,
we have been told that its recent releases are spec-compliant on NULL
handling.  The fact that 'transform_null_equals' exists (and was even
the default PG behavior for awhile) arises from the fact that some older
versions of MS Access expect this behavior.  Presumably that means that
MS has at some point shipped a database that behaves that way ...

            regards, tom lane