From: Theodore Petrosky <tedpet5@yahoo.com>
To: HR <hre@netpointers.com>
To: pgsql-sql@postgresql.org
Subject: Re: Bad encoding in URL
Date: Tue, 7 Oct 2003 12:11:34 -0700 (PDT)
Message-ID: <20031007191134.5867.qmail@web41002.mail.yahoo.com> (raw)
In-Reply-To: <1065437641.591496@www.webhosting.dk>
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 <hre@netpointers.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tedpet5@yahoo.com, hre@netpointers.com
Subject: Re: Bad encoding in URL
In-Reply-To: <20031007191134.5867.qmail@web41002.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox