Or try plpython. You can write triggers in plpython directly.
--elein
On Monday 13 January 2003 18:39, Tom Lane wrote:
> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
----------------------------------------------------------------------------------------
elein@varlena.com Database Consulting www.varlena.com
I have always depended on the [QA] of strangers.