Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 466819FB24B for ; Wed, 21 Mar 2007 00:02:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 52839-03 for ; Wed, 21 Mar 2007 00:02:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id C07369FA618 for ; Wed, 21 Mar 2007 00:02:33 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HTr5i-0008CW-Gx for pgsql-sql@postgresql.org; Wed, 21 Mar 2007 04:02:22 +0100 Received: from 85.187.136.11 ([85.187.136.11]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 21 Mar 2007 04:02:22 +0100 Received: from milen by 85.187.136.11 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 21 Mar 2007 04:02:22 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: "Milen A. Radev" Subject: Re: Substitute Date: Wed, 21 Mar 2007 05:02:56 +0200 Lines: 16 Message-ID: References: <46007447.8010202@correolux.com.mx> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 85.187.136.11 User-Agent: Mozilla Thunderbird 1.5.0.10 (Windows/20070221) In-Reply-To: <46007447.8010202@correolux.com.mx> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.65 tagged_above=0 required=5 tests=AWL, BAYES_05, RCVD_NUMERIC_HELO, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/277 X-Sequence-Number: 27915 Judith написа: > Hello everybody.... > > somebody knows, how I can substitute in a query if a field contains a > character that I want to be shown with other character? > > for example if I have a \n I want to shows me a ~ in the result of the > select > Look for 'replace' here - http://www.postgresql.org/docs/8.2/static/functions-string.html. -- Milen A. Radev