X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 51BAF475EEE for ; Mon, 28 Apr 2003 11:02:18 -0400 (EDT) Received: from smtp-out.net.ipl.pt (31.220.137.193.in-addr.arpa [193.137.220.31]) by postgresql.org (Postfix) with ESMTP id C96AF475D91 for ; Mon, 28 Apr 2003 11:02:15 -0400 (EDT) Received: (qmail 32194 invoked by uid 508); 28 Apr 2003 16:02:09 +0100 Received: from rutes@eselx.ipl.pt by smtp-int.net.ipl.pt by uid 505 with qmail-scanner (sophie: 2.14/3.68. spamassassin: 2.50. Clear:. Processed in 0.060266 secs); 28 Apr 2003 15:02:09 -0000 X-IPLNet-RcptTo: pgsql-sql@postgresql.org Received: from matrix.eselx.ipl.pt (193.137.237.148) by 0 with SMTP; 28 Apr 2003 16:02:08 +0100 Received: from [172.21.3.60] (helo=eselx.ipl.pt) by matrix.eselx.ipl.pt with esmtp (Exim 3.35 #1 (Debian)) id 19AA8W-0000uu-00 for ; Mon, 28 Apr 2003 16:01:44 +0100 Message-ID: <3EAD4293.30902@eselx.ipl.pt> Date: Mon, 28 Apr 2003 16:02:43 +0100 From: rute solipa User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: replace function Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-12.5 required=5.0 tests=BAYES_01,TO_ADDRESS_EQ_REAL,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/416 X-Sequence-Number: 13117 hi everyone, i've got an oracle query that goes like this: select replace (v.ds_conf, 'ns', 'p/fazer') as conf. from tb_visitas the result of this query is everytime is find string 'ns' it will be replaced by 'p/fazer'. does any one can tell me how do i do this in postgresql. kind regards, rute