title: more than one row returned by a subquery
body: <p>I am writing a query to insert values in a table.
  It is giving me an error.</p>
  
  <p>My query is:</p>
  
  <pre><code>INSERT INTO res_partner(
                          name,
                          company_id,
                          create_date,
                          street,
                          city,
                          display_name,
                          zip,
                          supplier,
                          ref,
                          is_company,
                          customer,
                          street2,
                          employee,
                          write_date,
                          active,
                          write_uid,
                          lang,
                          create_uid,
                          notify_email) 
         VALUES(
                (SELECT shipping_address_name FROM temp_unicom),
                1,
                LOCALTIMESTAMP,
                (SELECT shipping_address_line_1 FROM temp_unicom;),
                (SELECT shipping_address_city FROM temp_unicom),
                (SELECT shipping_address_name FROM  temp_unicom),
                (SELECT shipping_address_pincode FROM temp_unicom),
                FALSE,
                (Select sale_order_item_code FROM temp_unicom),
                FALSE,
                TRUE,
                (SELECT shipping_address_line_2 FROM temp_unicom),
                FALSE,
                LOCALTIMESTAMP,
                TRUE,
                1,
                'en_US',
                1,
                'always');
  </code></pre>
  
  <p>Error:</p>
  
  <p><code>ERROR:  more than one row returned by a subquery used as an expression</code></p>
  
  <p>********** Error **********</p>
  
  <pre><code>ERROR: more than one row returned by a subquery used as an expression
  SQL state: 21000
  </code></pre>
  
  <p>I know that each select subquery returns multiple rows, but I don't know how to fix the error.
  I have approximately 15,000 rows in my <code>temp_unicom</code> table and I am trying to insert data from <code>temp_unicom</code> to <code>res_partner</code>.</p>