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