Re: Bug #638: Buggy select statment with numeric

pgsql-bugs(at)postgresql(dot)org writes:
>> select * from t where n ISNULL;
> n | s
> ---+--------------
> | asdasdasd
> | qqqqqqqqqqqq
> (2 rows)

>> select * from t where n=NULL;
> n | s
> ---+---
> (0 rows)

This is not a bug.

However, you can make 7.2 work in that braindead Microsoft-compatible
style if you wish to. See the transform_null_equals parameter.

regards, tom lane