X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 32ECBD8A0F for ; Thu, 8 Sep 2005 18:25:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31837-04 for ; Thu, 8 Sep 2005 21:25:16 +0000 (GMT) Received: from mailout08.sul.t-online.com (mailout08.sul.t-online.com [194.25.134.20]) by svr1.postgresql.org (Postfix) with ESMTP id 096F0D889A for ; Thu, 8 Sep 2005 18:25:17 -0300 (ADT) Received: from fwd35.aul.t-online.de by mailout08.sul.t-online.com with smtp id 1EDTtV-0004i9-00; Thu, 08 Sep 2005 23:25:17 +0200 Received: from localhost (Zk2oFsZbZeinvW8xMq5YOd-fwheAtJIcOi5skmRt2-CMoN3aAJLi8Q@[172.20.101.250]) by fwd35.aul.t-online.de with esmtp id 1EDTtJ-1Zs2Eq0; Thu, 8 Sep 2005 23:25:05 +0200 MIME-Version: 1.0 Date: Thu, 8 Sep 2005 23:25:05 +0200 To: pgsql-sql@postgresql.org X-UMS: email X-Mailer: TOI Kommunikationscenter V6-0PL1 Subject: how to replace From: =?ISO-8859-1?Q?=22Michael_H=F6ller=22?= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit Message-ID: <1EDTtJ-1Zs2Eq0@fwd35.aul.t-online.de> X-ID: Zk2oFsZbZeinvW8xMq5YOd-fwheAtJIcOi5skmRt2-CMoN3aAJLi8Q@t-dialin.net X-TOI-MSGID: d871b71c-9d78-4507-96cd-91e4f5f96fb4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/91 X-Sequence-Number: 22638 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