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