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 <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
