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..