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

Reply via email to