Re: Bug #638: Buggy select statment with numeric - Mailing list pgsql-bugs

pgsql-bugs@postgresql.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