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