Sorry - thats what I mean - the table (as redefined by simon) create table lookup (rowindex int, rangestart int, rangeend int)
values in rowindex are not unique so I cannot make this column a primary key so i am not sure whether RTrees would be any help in this scenario On 5 July 2013 14:39, Igor Tandetnik <i...@tandetnik.org> wrote: > On 7/5/2013 9:13 AM, Paul Sanderson wrote: > >> my primary key would not be unique :( >> > > That's an oxymoron - primary key is unique, by definition. > > -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users