title: PostgreSQL ERROR: INSERT has more target columns than expressions, when it doesn't
body: <p>So I'm starting with this...</p>
  
  <pre><code>SELECT * FROM parts_finishing;
  </code></pre>
  
  <p>...I get this...</p>
  
  <blockquote>
    <p>id, id_part, id_finish, id_metal, id_description, date,
    inside_hours_k, inside_rate, outside_material</p>
    
    <p>(0 rows)</p>
  </blockquote>
  
  <p>...so everything looks fine so far so I do this...</p>
  
  <pre><code>INSERT INTO parts_finishing 
  (
   id_part, id_finish, id_metal, id_description, 
   date, inside_hours_k, inside_rate, outside_material
  ) VALUES (
  ('1013', '6', '30', '1', NOW(), '0', '0', '22.43'), 
  ('1013', '6', '30', '2', NOW(), '0', '0', '32.45'));
  </code></pre>
  
  <p>...and I get...</p>
  
  <blockquote>
    <p>ERROR:  INSERT has more target columns than expressions</p>
  </blockquote>
  
  <p>Now I've done a few things like ensuring numbers aren't in quotes, are in quotes (would love a table guide to that in regards to integers, numeric types, etc) <em>after</em> I obviously counted the number of column names and values being inserted. I also tried making sure that all the commas are commas...really at a loss here. There are no other columns except for <code>id</code> which is the <code>bigserial</code> <code>primary key</code>.</p>