Martin Marques wrote:
> El Jue 15 Abr 2004 08:55, Sebastian Böck escribió:
>
>>Hello,
>>
>>is there a simple operator to determine whether the OLD.value and
>>NEW.value are different. The <> operator is not working on NULL's.
>>
>>I need something like this:
>>NEW.val <> Old.val OR
>>NEW.val IS NULL AND OLD.val IS NOT NULL OR
>>NEW.val IS NOT NULL AND OLD.val IS NULL
>
>
> (NEW.val <> Old.val) OR
> (NEW.val IS NULL AND OLD.val IS NOT NULL) OR
> (NEW.val IS NOT NULL AND OLD.val IS NULL)
>
> You forgot the parenthesis, to group the conditions accordingly
Yes i did in my mail, but that's not the question.
I wanted to know if there is a special operator that does exactly
this.
Sebastian