Replace-function
Started by Victor Spång Arthurssonalmost 22 years ago2 messagesgeneral
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
Re: Replace-function
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:
Show quoted text
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?