Skip site navigation (1) Skip section navigation (2)

Re: How to html-decode a html-encoded field

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to html-decode a html-encoded field
Date: 2012-04-10 16:01:38
Message-ID: CAFj8pRDr-QTso+oC6BTD06o6VcfHj3YGFT3aLsWJACOv9s4g=g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
Hello

see http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Function_for_decoding_of_url_code

Regards

Pavel Stehule

2012/4/10 JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>:
> 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&#39;&#39;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

In response to

pgsql-sql by date

Next:From: kevalshahDate: 2012-04-11 11:57:07
Subject: Re: sintax error
Previous:From: JORGE MALDONADODate: 2012-04-10 15:59:13
Subject: How to html-decode a html-encoded field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group