Thread: Replace-function

I have looked in the manual, but can't find a function to use in SQL
which replaces chars/strings with given ones…

For example; replace all a with b in the field testfield…

Anyone?

Sncerely

Victor

How about the REPLACE function?

See http://www.postgresql.org/docs/7.4/interactive/functions-string.html

John Sidney-Woollett

Victor Spång Arthursson wrote:

> I have looked in the manual, but can't find a function to use in SQL
> which replaces chars/strings with given ones…
>
> For example; replace all a with b in the field testfield…
>
> Anyone?
>
> Sncerely
>
> Victor
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>