[EMAIL PROTECTED] 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to