Re: Altering field passed as parameter to plpgsql trigger

Steve Crawford wrote:

> What is the correct syntax for the line:
> new.field_to_alter = some_computed_value;

Can't be done in plpgsql - it's too static a language. On first call,
that assignments basically gets compiled into a planned query and from
then on you're stuck.

You can use pl/tcl or pl/perl etc. since they're more dynamic.

> Also, does plpgsql have a preferred way to identify the table that fired
> the trigger. I see the syntax for C but not for plpgsql.

TG_RELNAME / TG_TABLE_NAME - it's in the plpgsql/triggers section of the
manual.

--
   Richard Huxton
   Archonet Ltd