Re: [GENERAL] Copy rows, remember old and new pkey

2012-11-26 Thread Vlad K.
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

Re: [GENERAL] Copy rows, remember old and new pkey

2012-11-26 Thread Merlin Moncure
On Mon, Nov 26, 2012 at 3:35 AM, Vlad K. wrote: > > 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 is > INSERT INTO a SELECT * FROM a where a.x=y; > > I guess I can do it with a

[GENERAL] Copy rows, remember old and new pkey

2012-11-26 Thread Vlad K.
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