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

From Szymon Guz
Subject Re: Need help on updating an entire column with a list of values, I have.
Date
Msg-id e4edc9361003260735s73d97212qa58bb7203108bded@mail.gmail.com
Whole thread Raw
In response to Re: Need help on updating an entire column with a list of values, I have.  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: Need help on updating an entire column with a list of values, I have.  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List 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 by date:

Previous
From: Alan McKay
Date:
Subject: Solid State Drives with PG (was: in RAM DB)
Next
From: Tim Landscheidt
Date:
Subject: Using readline for frequently used queries