Thomas Lockhart <lockhart@fourpalms.org> writes:
> Yes, this is an explicit feature in our parser to help out poor MSAccess
> souls who have a product which generates illegal SQL queries. We put in
> a specific rule to convert "anything=NULL" to "anything IS NULL", which
> *is* legal syntax.
It should also be noted that as of 7.2, this transformation is optional
(see "transform_null_equals" runtime parameter), and the default is NOT
to make the transformation --- ie, as of 7.2 the default behavior is
SQL-spec-compliant:
regression=# select null = null;
?column?
----------
(1 row)
regression=# set transform_null_equals TO 1;
SET VARIABLE
regression=# select null = null;
?column?
----------
t
(1 row)
regression=#
regards, tom lane
