Simon, Fair point and agreed. We?ll update it.
Rob > On 17 Sep 2015, at 13:56, Simon Slavin <slavins at bigfraud.org> wrote: > > > 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. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users