Richard Huxton wrote:
> 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.
Great. I'll use another approach.
>> 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.
>
Thanks. I did find that after another cup of coffee. :)
Cheers,
Steve