Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA8MQHm22919 for ; Thu, 8 Nov 2001 17:26:40 -0500 (EST) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 359 for ; Thu, 8 Nov 2001 15:16:06 -0700 Message-ID: <3BEB0B18.3D6604DA@waterford.org> Date: Thu, 08 Nov 2001 15:45:44 -0700 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Postgres SQL Mailing List Subject: substring replacement Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/137 X-Sequence-Number: 5521 Hi everybody, I am wondering if there is an efficient way to get rid of line breaks ('\n') and tabs ('\t') from a string. Suppose, I have the following query: SELECT description FROM device; I don't want the returned description column to contain '\n' and '\t'. Is it possible to do it efficiently? thanks, Oleg