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 and I wonder if there is a function that I can
include in such a statement for this purpose, for example "SELECT
htmldecode(fld1) FROM table1". I will appreciate anu comments about my
issue.

Respectfully,
Jorge Maldonado

Hello

see http://postgres.cz/wiki/PostgreSQL_S..._of_url _code

Regards

Pavel Stehule

2012/4/10 JORGE MALDONADO <jorgemal1960 (AT) gmail (DOT) com>:
--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

On 2012-04-10, JORGE MALDONADO <jorgemal1960 (AT) gmail (DOT) com> wrote:
if you don't mind gettin an exception or the wrong answer on invalid
input you can abuse xpath thusly:

with sample as ( values ('magic'),('s&amp;witch'),('to&#x61;ster'))
select
column1 as input ,
(xpath('/z/text()', ('<z>'|| column1 ||'</z>')::xml))[1] as output
from sample

--
⚂⚃ 100% natural


--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql