Re: how to replace

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