title: How to use Select query in encode decode function postgresql
body: <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>