On 26-02-2012 17:11, Luuk wrote: > 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' > >
but you probably new that already.... ;) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
