title: Postgres (ERROR: column "date_deadline" is of type date but expression is of type text)
body: <pre><code>update res_user set date_of_birth= '1991-07-30' where name = 'USER1';
  </code></pre>
  
  <p>This work but can update just one row.</p>
  
  <p>In my case I want to update multiple rows with different data in the same query so I wrote that, it doesn't work unfortunately.</p>
  
  <p>Query:</p>
  
  <pre><code>update res_user as ru set
  date_of_birth = n.date_of_birth
  from (values
      ('1991-07-30','User1'),
      ('1980-06-30','User2'),
      ('1975-02-12','User3'),
  ) as n(date_of_birth, name)
  where n.name = ru.name;
  </code></pre>
  
  <p>Result:</p>
  
  <pre class="lang-none prettyprint-override"><code>ERROR:  column "date_of_birth" is of type date but expression is of 
  type text
  LINE 2:     date_of_birth = n.date_of_birth
                          ^
  HINT:  You will need to rewrite or cast the expression.
  </code></pre>