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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
