Search Postgresql Archives

Re: Need help on updating an entire column with a list of values, I have.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





W dniu 26 marca 2010 15:21 użytkownik Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> napisał:
create temporary table, insert your data, and than run update with join against the table you wish to modify. And than drop your temp table.
simple.


It would be a nice solution, assuming that we know anything about the correlation between the new values list and the B column values. In fact we have some values in a random order in the database and a list of values that isn't correlated with the database values.

regards
Szymon

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux