On 17 Sep 2015, at 12:58pm, Rob Willett <rob.sqlite at robertwillett.com> wrote:
> CREATE TABLE "postcode" ( > "postcode" text NOT NULL, As an incidental tip not related to your question, I would recommend that you don't have a column name which is the same as a table name. Call the table 'locations' instead or something. It's not illegal in SQL, but it can be confusing if you come back to it in a few years. Simon.