title: Insert multiple rows into a table with only one value changing
body: <p>Let's say I have a table with the following columns:</p>
  
  <p>field 1 | field 2 | field3 | field4</p>
  
  <p>I want to insert multiple rows in this table, but the values of field1, field2 and field3 are identical for each row. Only the value of field4 will change.</p>
  
  <p>Obviously I could insert each row separately but the resulting query would be a bit ugly, and I'm wondering if there is a more efficient / elegant way to do it.</p>
  
  <p>I thought of something like this for example:</p>
  
  <pre><code>insert into my_table (field1, field2, field3, field4) values (foo, bar, baz, ('value one','value two','value three','value four'))
  </code></pre>
  
  <p>And the result would be:</p>
  
  <pre><code>field1 | field2 | field3 | field4
  foo    | bar    | baz    | value one
  foo    | bar    | baz    | value two
  foo    | bar    | baz    | value four
  foo    | bar    | baz    | value five
  </code></pre>
  
  <p>In practice, the 'field4' column is a string type, and the different values are known when I write the query. There's no need to get them from a table or anything (although if it's possible, i'm interested in a solution that can do it)
  Is this posible or will I have to write each insert separately ?</p>
  
  <p>EDIT: I've changed the question to be more clear about the data type of the changing column (general textual data) and where does the data come from. Sorry for those who have already answered without these information.</p>
  
  <p>Thanks.</p>