On 16 Jun 2014, at 1:10pm, Richard Hipp <d...@sqlite.org> wrote: > > That's not quite the same thing. "x BETWEEN ?1 AND ?2" means "x>=?1 AND > x<=?2". > > Now, if x is the INTEGER PRIMARY KEY (and thus is guaranteed to be an > integer) you could say: > > WHERE rowid BETWEEN max(?1,?3+1) AND ?2
I stand corrected. Nice trick. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
