On May 18, 2013, at 3:13 AM, Keith Medcalf <kmedc...@dessus.com> wrote:
> This applies *only* to the rowid (integer primary key). Other indexes (as in > CREATE INDEX) are always unique since the key always contains the rowid as > the final (unspoken) component. A "unique" index must be unique without > considering the (unspoken) rowid component of the key. So a manual index > that is created with the rowid as the final component is always unique > (whether you specify it or not) and the rowid is placed in the key twice > (once spoken, once unspoken). Well spoken, Sir. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users