Subject Re: [firebird-support] Why NULL <> NULL ?
Author Lucas Franzen
jasajona schrieb:
> In trigger I have:
> --
> if (field1 = field1) then ...
> --
> when field1 = null, field2 = null
> (field1 = field2) = false :(
> so I have to make an exception for null case, that is very ilogical.

Often used example:
I don't know how much money you've got in your wallet, so the value is
NULL (unknown).

You don't know how much money I've got in my wallet, so it's NULL, too.

So your conclusion is that we both have the same amount of money in our
wallets, since we both have NULL....