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.

Reply via email to