Hello! 1. See internal sqlite instarray interface: http://sqlite.mobigroup.ru/src/finfo?name=src/test_intarray.c http://sqlite.mobigroup.ru/src/finfo?name=src/test_intarray.h http://sqlite.mobigroup.ru/src/finfo?name=test/intarray.test
Note: http://sqlite.mobigroup.ru include official SQLite trunk branch but anonymous autorization is not required. 2. See my Tablefunc extension here: http://sqlite.mobigroup.ru/src/dir?name=ext/tablefunc As example: create table testrange(rowid); select intrange2table (1,10,1,'testrange'); select * from testrange; 1 2 3 4 5 6 7 8 9 10 select intrange2table (10000000000,100000000000,10000000000,'testrange'); select * from testrange; 1 2 3 4 5 6 7 8 9 10 10000000000 20000000000 30000000000 40000000000 50000000000 60000000000 70000000000 80000000000 90000000000 100000000000 Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
