Arnaud Lesauvage schrieb:
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 ?
I was simply using a stored function using pl/pythonu with
urllib (split and unquote). Works flawlessy :-)
Regards
T.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
