On 26-02-2012 17:06, Rita wrote: > if I can have a primary key of t+user (which would be ideal) how can I do a > search? Can I do a key partial key scan in sqlite? For instance, give me > the record for user 'foo' from time 'x to y' ?
select t, user, price from main where t between x and y and user='foo' _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
