On Sun, Jan 5, 2014 at 7:12 AM, Hadley Wickham <h.wick...@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]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
