title: Postgres calling a void function
body: <p>I have a void plsql function:</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION do_something(p_id BIGINT) 
  RETURNS void
  AS $$
  BEGIN
     insert ....
  END;
  $$ LANGUAGE plpgsql SECURITY DEFINER;
  </code></pre>
  
  <p>I want to call this function from another plsql function, but inside a query like:</p>
  
  <pre><code>SELECT  do_something(m.id) 
  FROM    MyTable m
  WHERE   m.IsActive;
  </code></pre>
  
  <p>When I run the <code>sproc</code> i get:</p>
  
  <blockquote>
    <p>ERROR:  query has no destination for result data HINT:  If you want to
    discard the results of a SELECT, use PERFORM instead.</p>
  </blockquote>
  
  <p>Is it possible to call a void function as part of a <code>select</code> statement? </p>