"David U." <davidu(at)everydns(dot)net> writes:
> I'm writing a trigger to change the third field in a varchar record. (it's
> an SOA field from DNS) and I can do it in plperl but since it needs to be a
> trigger I have to do it in plpgsql (or other right?).
There's nothing to stop you from calling a plperl function from a
plpgsql trigger function. If you've got complicated string-mashing
requirements, I'd certainly recommend coding them in plperl (or pltcl).
Someday someone should get around to implementing trigger support for
plperl, but in the meantime a two-layer approach seems like your answer.
regards, tom lane