Re: Variable column name in plpgsql function - Mailing list pgsql-general

George Woodring wrote:
>
> Is possible to declare a variable to build the column name
>
> Tableid varchar(20) := TG_RELNAME || ''id'';
>
> And then use this variable to get the PK value?
>
> Tableidvalue int4 := NEW.tableid;

No. You can build a dynamic query via EXECUTE, but that can't access
NEW/OLD.

--
   Richard Huxton
   Archonet Ltd