On 11/26/2012 07:15 PM, Merlin Moncure wrote:
I don't think you need a CTE or a loop unless you want to delete the
old rows. Why not (hard to say exactly how it will work):
INSERT INTO a(old_id, new_id, ...)
SELECT id, new_id(), ...
from a;
?
Well, the table A, in which I'm copying rows, does
Hello list,
I need to make a copy of certain rows in table A and remember the
original pkey and new pkey in some temporary table B. Basically the copy
statement isINSERT INTO a SELECT * FROM a where a.x=y;
I guess I can do it with a plpgsql function and a FOR loop statement,
because I n
On 11/24/2012 10:15 AM, Rafal Pietrak wrote:
Some improvement in passwords safety could be gained, if the database
table access methods (e.g. SELECT...) provided means to limit that
access to just one entry at a time, and return results only when
(password) column hash was equal for a single ent
