Re: Determine column name from trigger

"Envex Developments" <mwagner(at)envex(dot)net> writes:
> FOR x IN 1 .. 3 LOOP
> IF OLD.ux NOT = NEW.ux THEN

I think you'll have to bite the bullet and write it out as three
separate tests:

if old.u1 <> new.u1 then
...
end if;
if old.u2 <> new.u2 then
...
end if;
if old.u3 <> new.u3 then
...
end if;

You could possibly do something that iterates through the column names
in pltcl, but plpgsql doesn't have that much flexibility.

regards, tom lane