> On Thu, 17 Sep 2015 13:55:51 +0100 Simon Slavin wrote > >> At the end of the CREATE TABLE statement add keywords: "WITHOUT >> ROWID". Like this: >> >> CREATE TABLE postcode( >> postcode TEXT, >> long TEXT, >> lat TEXT >> ) WITHOUT ROWID; > > The documentation suggests that you need to explicitly declare a PRIMARY KEY, > so you would need something more like > > CREATE TABLE postcode( > postcode TEXT PRIMARY KEY, > long TEXT, > lat TEXT > ) WITHOUT ROWID; > > but perhaps I misunderstood.
Elsewhere in that email (on another topic) a correspondent urged that the outcome should be stated, the requirements understood so the proposed solution could address that, not how to improve code snippets. I think that applies here. In this particular thread I think an important element is that postcode will not be unique, if Australia Post's version of this is typical. One postcode covers several suburbs. I guess this will fundamentally alter the approach. A blisteringly fast lookup retrieving the wrong result may not be all that useful. Chris Waters
