Michael Höller wrote:
> Hello,
>
> I initially thought this is simple.. I want to relpace a character to
> nothing. Eg. relace "B" to "" -> ABCD to ACD.
>
> All me approches vaild but I am sure that I have seen it already and
> think it was not tricky..
>
> Can someone please help me ?
From the manual:
replace(string text, from text, to text) returns text Replace all occurrences in string of substring from with
substringto.
<http://www.postgresql.org/docs/8.0/interactive/functions-string.html>
To replace only on output, for example:
SELECT replace (sometextcolumn, from 'B', to '') FROM sometable;
To replace the data,
UPDATE sometable SET sometextcolumn = replace (sometextcolumn, from 'B', to '');
HTH,
Owen