URI_PERCENT_DECODE
Decodes a percent-encoded Universal Resource Identifier (URI) according to the RFC 3986 standard.
Syntax
URI_PERCENT_DECODE (expression)
Behavior Type
Parameters
expression |
(VARCHAR) is the string to convert. |
Examples
The following example invokes uri_percent_decode on the Websites column of the URI table and returns a decoded URI:
=> SELECT URI_PERCENT_DECODE(Websites) from URI; URI_PERCENT_DECODE ----------------------------------------------- http://www.faqs.org/rfcs/rfc3986.html x xj%a% (1 row)
The following example returns the original URI in the Websites column and its decoded version:
=> SELECT Websites, URI_PERCENT_DECODE (Websites) from URI; Websites | URI_PERCENT_DECODE ---------------------------------------------------+--------------------------------------------- http://www.faqs.org/rfcs/rfc3986.html+x%20x%6a%a% | http://www.faqs.org/rfcs/rfc3986.html x xj%a% (1 row)