Re: RE: search/replace in update

Jeff,

> Which function would you be suggesting?  I hope not "translate".
> That works
> on characters, not strings.  Easy to confuse if you don't read
> closely
> enough, as I found to my cost.

Hm?  Darn!  I'd swear there was a "replace" function in the various
string manipulation functions.  My mistake.

> Easiest way using these functions would be:
> UPDATE table 
> SET mobile_number = '07889' || substr (mobile_number, 5) 
> WHERE mobile_number LIKE '0589%';
> Alternatively, you could define a generic search/replace function
> like:
> CREATE FUNCTION search_replace (text, text, text)
> RETURNS text AS '
> RETURN @_[0] =~ s/@_[1]/@_[2]/
> ' LANGUAGE 'plperl';

Hey, thanks!  Do I have to "CREATE TRUSTED LANGUAGE" to enable plperl?

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco