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