On Sun, Jan 5, 2014 at 7:12 AM, Hadley Wickham <h.wickham@gmail.com> wrote:

> > Though I admit that it bothers me that, although the SQLite syntax
> > documentation for "CREATE INDEX", here:
> > http://www.sqlite.org/lang_createindex.html
> > does say the database name is optional, it also says that,  if you
> include
> > it, the period the period between the db name and the table name is
> > required.
>
> I think you've misinterpreted what database name means in this context
> - sqlite only has one database per file called "main". You can attach
> others using the ATTACH command
> (http://www.sqlite.org/lang_attach.html).
>
> Hadley
> --
> http://had.co.nz/
>

My goodness.

You took that all the way from frustrating nonsense to sensible and obvious
with a single line of explanation.

A little breathless, andrewH

-- 
J. Andrew Hoerner
Director, Sustainable Economics Program
Redefining Progress
(510) 507-4820

	[[alternative HTML version deleted]]


