Re: [SQL] Equality operators on NULL values

Bertrand Petit writes: > NULL=NULL ==> t > 1=NULL==> NULL (or anything else as long as it is not t) > 1=1 ==> t > 1=2 ==> f > Is there a stock replacement operator that would behave like > the second truth table? No, but why not write (a = b

[SQL] Equality operators on NULL values

(in)Equality operators evaluates to NULL when any of their arguments are NULL as summarized bellow. NULL=NULL ==> NULL 1=NULL==> NULL 1=1 ==> t 1=2 ==> f I have a case where I need to delete rows from table A for records that are designated