[GENERAL] Update Join ?

[kevin kempter]

Hi List;

Does Postgres allow updates based on the context of a sub-query,  
something like the sample below ?



1) Insert data (real_tab.keyID and real_tab.data_desc)  into a temp  
table (temp_tab)

2) update real_tab
       set real_tab.data_desc = temp_tab.data_desc
      join real_tab on real_tab.keyID = temp_tab.keyID ;

Thanks in advance..