Re: Determine column name from trigger - Mailing list pgsql-general

"Envex Developments" <mwagner@envex.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