How to use Select query in encode decode function postgresql
<p>I have checked on web I got one example like </p>

<pre><code>select convert_from(decode(encode('abc', 'base64'), 'base64'), 'UTF8');
</code></pre>

<p>now I want to decode my string so I am trying the same with below mentioned </p>

<pre><code>select convert_from(decode(encode((select resumestring from submitapplications where id=1030), 'base64'), 'base64'), 'UTF8');

ERROR:  function encode(text, unknown) does not exist
</code></pre>

<p>LINE 1: select convert_from(decode(encode((select resumestring from ...</p>