Re: Cleaning text with function?

Patrick,

> Currently I have a perl script that I use to cleanse text fields in a
> file
> for use in our mainframe. I would like to do this as a function and
> bypass
> using perl if possible. Is this possible? I do not have plperl
> installed
> on the database due to server restrictions.
> Example of current perl statement:

I'm afraid that you really need PL/Perl or PL/Tcl for this.

While it would be possible to do the text replacement with PL/pgSQL or
pglibq, it would be much, much slower -- basically, you'd need to loop
through the text character-by-character and test each character for the
correct types. If you want an example of this approach, search the
archives of the SQL list for the STRIPNUMERIC function which I posted
some time ago.

Perl and Tcl are known for their superior text-processing capabilities
for a reason.

-Josh Berkus