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

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: Need help on updating an entire column with a list of values, I have.
Дата
Msg-id e4edc9361003260735s73d97212qa58bb7203108bded@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need help on updating an entire column with a list of values, I have.  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Ответы Re: Need help on updating an entire column with a list of values, I have.  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general


W dniu 26 marca 2010 15:21 użytkownik Grzegorz Jaśkiewicz <gryzman@gmail.com> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alan McKay
Дата:
Сообщение: Solid State Drives with PG (was: in RAM DB)
Следующее
От: Tim Landscheidt
Дата:
Сообщение: Using readline for frequently used queries