Re: String manipulation in plpgsql - Mailing list pgsql-novice

From Tom Lane
Subject Re: String manipulation in plpgsql
Date
Msg-id 14473.1047170564@sss.pgh.pa.us
Whole thread Raw
In response to String manipulation in plpgsql  ("Rod Kreisler" <rod@23net.net>)
List pgsql-novice
"Rod Kreisler" <rod@23net.net> writes:
> Is there a way to do string manipulation in plpgsql, or should I just use
> plperl?  It's just been SO long since I've used perl, trying to avoid it....

plpgsql's string-handling functions are the same as SQL's, ie, pretty
primitive.  If you need to do anything more complex than simple
substring extraction, I'd think perl is the path of least resistance.
(pltcl and plpython are alternatives, too, if you like those languages
better than perl.)

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stored procedure - change columns in a table that is
Next
From: Aspire Something
Date:
Subject: Python in Postgresql