radevojvodic wrote:

>
> Thanks Ibrahim,
>
> That will probably work. The only problem with that solution is that
> end-user will complete his task and the value wouldn't change

In V2, there's a new comparison operator IS [NOT] DISTINCT FROM which
does exactly what you want. Until then, you have to use...

if (f2 is not null) and
(old.f3 <> new.f3) or
(old.f3 is null and new.f3 is not null) or
(old.f3 is not null and new.f3 is null) or
(old.f4 <> new.f4) or
(old.f4 is null and new.f4 is not null) or
(old.f4 is not null and new.f4 is null)
exception...


Regards,


An