decode_uri¶
Description¶
Replace %-encoded escape sequences in a string with unencoded plain text.
However, encoded characters in the set #$&+,/:;=?@ are kept encoded. NULL if input contains an invalid encoded sequence.
See also decode_uri_component, decode_base64.
Return type¶
string
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
decode_uri(str)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
str |
string |
no |
no |
none |
Examples¶
make_col d:decode_uri('%32%5E%33%20%3D%20%38%3B')
Decoding the example string results in ‘2^3 %3D 8%3B’ which is different from decode_uri_component.