[GENERAL] URL Decoding

[Arnaud Lesauvage]

Hi List !

I am looking for an easy URL decoding function.
I thought about using regexp_replace, but I cna't get it to 
work :

SELECT regexp_replace('foo%B5bar', '%(..)', '\x\\1' , 'g');
> 'fooxB5bar'

I wanted to replace %BE with the character \xB5 (µ, I 
think), but of course I am doing this wrong...
Is there a simple way t odo this ?

Thanks a lot !

--
Arnaud

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings