"= Null" <> "is Null"?

From: Durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "= Null" <> "is Null"?
Date: 2009-07-08 11:30:35
Message-ID: 9e384ef60907080430r4d7a4af7h6c33b28c2c19bc3a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ms swati chande 2009-07-08 11:52:33 Re: [Re: Password?]
Previous Message Abbas 2009-07-08 11:18:52 Re: Password?