Re: how to do a find and replace

> update media_instance set location=replace(location,'v.','')
> where location like '%/0/v.%'

For more complex search/replace operations, 8.1 provides an interesting
function, named 'regexp_replace'.
It probably goes unnoticed because although there is a small reference in
the manual in section 'E.1.3.6. Data Type and Function Changes'
(http://www.postgresql.org/docs/8.1/interactive/release.html#RELEASE-8-1)
and a description in section '9.7.3 POSIX Regular expressions'
(http://www.postgresql.org/docs/8.1/interactive/functions-matching.html) it
isn't mentioned in section '9.4. String Functions and Operators'
(http://www.postgresql.org/docs/8.1/interactive/functions-string.html)

Hélder M. Vieira