Re: String manipulation in plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rod Kreisler" <rod(at)23net(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: String manipulation in plpgsql
Date: 2003-03-09 00:42:44
Message-ID: 14473.1047170564@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Rod Kreisler" <rod(at)23net(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Aspire Something 2003-03-09 08:04:46 Python in Postgresql
Previous Message Tom Lane 2003-03-09 00:39:01 Re: Stored procedure - change columns in a table that is