Igor Tandetnik wrote: > On 6/19/2013 8:18 AM, Clemens Ladisch wrote: >> <http://www.sqlite.org/lang_attach.html> says: >> | If two or more tables in different databases have the same name and >> | the database-name prefix is not used on a table reference, then the >> | table chosen is the one in the database that was least recently >> | attached. >> >> As the first (i.e., most recently) attached, main always loses. > > You seem to have it backwards. The first would be least recent (that is, > oldest); the last would be most recent.
Sorry, you're right. The actual search order is first temp, then main, then any attached databases in attachment order. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users