Re: [sqlite] Selective update of a column

2010-11-18 Thread Amit Chaudhuri
Simon - thanks v. much. Makes complete sense now - and it does precisely what I wanted. :) {Appreciate the tip on the index - performance hasn't been an issue yet but I'm sure I'll end up using it.} On Wed, Nov 17, 2010 at 12:51 PM, Simon Slavin wrote: > > On 16 Nov 2010, at 3:29pm, Amit Chaudh

Re: [sqlite] Selective update of a column

2010-11-17 Thread Simon Slavin
On 16 Nov 2010, at 3:29pm, Amit Chaudhuri wrote: > The approach I tried was to perform 2 sequential updates using first the > fixed call source table then the mobile. I tried to restrict the update to > rows in target where the class of call (fixed or mobile) corresponded to the > content of the

[sqlite] Selective update of a column

2010-11-17 Thread Amit Chaudhuri
Hi all, I can't work out how to do something I feel ought to be easy. Attached small file is designed to be .read to provide a test case. Explanation of what I'm trying to follows below. I have two separate but very similar source data sets, one for mobile one for fixed calls of various sub-typ