Re: String functions like split() and join() in plpgsql - Mailing list pgsql-general

From elein
Subject Re: String functions like split() and join() in plpgsql
Date
Msg-id 200301160131.h0G1VfUa163094@pimout2-ext.prodigy.net
Whole thread Raw
In response to Re: String functions like split() and join() in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: PostgreSQL and Data warehousing question
Next
From: Tom Lane
Date:
Subject: Re: Dropping functions with missing argument types