"= Null" <> "is Null"? - Mailing list pgsql-general

From Durumdara
Subject "= Null" <> "is Null"?
Date
Msg-id 9e384ef60907080430r4d7a4af7h6c33b28c2c19bc3a@mail.gmail.com
Whole thread Raw
Responses Re: "= Null" <> "is Null"?
Re: "= Null" <> "is Null"?
List pgsql-general
Hi!
select * from any where is_deleted = Null
select * from any where is_deleted in (Null)

They are show 0 record.

select * from any where is_deleted is Null

It is show all records.

Some of other DBs are uses Null as Null in >=< comparisons. Is PG not? What are the rules?

Thanks: dd

pgsql-general by date:

Previous
From: Pedro Doria Meunier
Date:
Subject: sslv3 alert illegal parameter
Next
From: Ms swati chande
Date:
Subject: Re: [Re: Password?]