"Jules Alberts" <jules.alberts@arbodienst-limburg.nl> writes:
> Code like this
> NEW.$1 := lower(NEW.$1)
> won't work, all I get is error messages :-(
Can't do that in plpgsql; it does not like run-time specification of
table or field names. You could try using EXECUTE but I doubt that
will work either for an assignment to NEW.
I'd suggest using pltcl, which is more amenable to run-time
determination of field names.
> mostly says the opposite. Is this possible at all? How do I read the
> TriggerData structure from whithin a pl/pgsql function?
You are looking for TG_ARGV[], though this is not your biggest
problem...
regards, tom lane
