title: "INSERT INTO SELECT" vs. "INSERT INTO VALUES ... (SELECT)"
body: <p>A short question: What is the better way and why?</p>
  
  <p>Using A  </p>
  
  <pre><code>INSERT INTO someTable(fieldA, fieldB, fieldC)
  SELECT 'consA', 'consB', other.value FROM other WHERE XXX
  </code></pre>
  
  <p>or using B:  </p>
  
  <pre><code>INSERT INTO someTable(fieldA, fieldB, fieldC) 
  VALUES ('constA', 'constB', (SELECT other.value FROM other WHERE XXX));
  </code></pre>
  
  <p>or something other ... ?</p>
  
  <p>(<code>x</code> can be any condtion to match a single row, Examples are working in postgresql)</p>