Re: [GENERAL] Chaining inserts ... This would be cool

2012-04-23 Thread Nick Apperson
thout the syntax or equivalent to what I originally posted. Thanks for the help anyway. On Mon, Apr 23, 2012 at 4:19 PM, Thom Brown wrote: > On 23 April 2012 21:49, Nick Apperson wrote: > > There are obviously workarounds for this, but I'm wondering why the > > following query

[GENERAL] Chaining inserts ... This would be cool

2012-04-23 Thread Nick Apperson
There are obviously workarounds for this, but I'm wondering why the following query shouldn't work. It seems like it should. With MVCC already present on the back-end, I can't see any reason other than additional parsing routines that this couldn't work: INSERT INTO old_login_id_to_new_account_id(