Re: [SQL] How to html-decode a html-encoded field

Hello see http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Function_for_decoding_of_url_code Regards Pavel Stehule 2012/4/10 JORGE MALDONADO : > I have a table with a varchar field, such a field is HTML ENCODED. So, for > example, the string "PLAIN WHITE T'S" is saved as "PLAIN WHITE T''S" > (dou

[SQL] How to html-decode a html-encoded field

I have a table with a varchar field, such a field is HTML ENCODED. So, for example, the string "PLAIN WHITE T'S" is saved as "PLAIN WHITE T''S" (double quotes are not part of the string, I use them for clarity only). I need to perform a SELECT statement on this table and get the values HTML DECODED