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 information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco