Treatment of Nulls

The set option ansinull determines whether or not evaluation of null-valued operands in SQL equality (=) or inequality (!=) comparisons and aggregate functions is SQL-standard-compliant.

This option does not affect how null values are evaluated in other kinds of SQL statements such as create table.