Michael, You practically solved it yourself in the subject of the email ;)
select replace('abcd','b','') from your_table;
Hope that helps, Anthony
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of "Michael Höller"
Sent: Thursday, September 08, 2005 5:25 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] how to replace
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 ?
Thanks a lot
Michael
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to
majordomo@postgresql.orgso that your message can get through to the mailing list cleanly