Re: String functions like split() and join() in plpgsql

"David U." <davidu@everydns.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