title: How to mention inserted table in subselect postgres?
body: <p>I need to insert some data in new column:</p>
  <pre><code>insert into orders (delivery_address) 
  select address 
  from addresses 
  where addresses.id = orders.address_id;
  </code></pre>
  <p>I found that i cannot mention inserted table 'orders' in subquery.
  Is there a way to do that?
  Thanks.</p>