Re: RE: search/replace in update
От | Josh Berkus |
---|---|
Тема | Re: RE: search/replace in update |
Дата | |
Msg-id | web-71995@davinci.ethosmedia.com обсуждение исходный текст |
Ответ на | RE: search/replace in update (Jeff Eckermann <jeckermann@verio.net>) |
Ответы |
Re: RE: search/replace in update
|
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: