[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