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

Rod Kreisler wrote:
> 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....
>

You can use any of the existing string functions, string concatenation,
etc. See:

http://developer.postgresql.org/docs/postgres/functions-string.html
and
http://developer.postgresql.org/docs/postgres/plpgsql-statements.html

as a start. Anything complex is probably a lot easier in plperl (or
pltcl or plpython) though.

HTH,

Joe