X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 650F3D1B585 for ; Tue, 7 Oct 2003 19:18:33 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 82320-10 for ; Tue, 7 Oct 2003 16:17:44 -0300 (ADT) Received: from web41002.mail.yahoo.com (web41002.mail.yahoo.com [66.218.93.1]) by svr1.postgresql.org (Postfix) with SMTP id EE1CDD1B591 for ; Tue, 7 Oct 2003 16:11:33 -0300 (ADT) Message-ID: <20031007191134.5867.qmail@web41002.mail.yahoo.com> Received: from [66.108.25.20] by web41002.mail.yahoo.com via HTTP; Tue, 07 Oct 2003 12:11:34 PDT Date: Tue, 7 Oct 2003 12:11:34 -0700 (PDT) From: Theodore Petrosky Subject: Re: Bad encoding in URL To: HR , pgsql-sql@postgresql.org In-Reply-To: <1065437641.591496@www.webhosting.dk> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/90 X-Sequence-Number: 15490 Maybe you want to look here: http://www.brasileiro.net/postgres/cookbook/ mimic oracle's replace function. versions in pltcl and plpgsql. If the function you want isn't built in to posgresql... Ted --- HR wrote: > Hi > > I have some URLs in a database but some of the URL > contain %3A and so on.. > > Is there an easy way of converting '%3A' to ':' ??? > > I cannot find any replace(String str, String str) > among the string > functions. > > ThankYou. > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to > majordomo@postgresql.org so that your > message can get through to the mailing list cleanly __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com