> On 16 Jun 2014, at 12:36pm, Richard Hipp <d...@sqlite.org> wrote: > > Instead of > > ... WHERE x BETWEEN ?1 AND ?2 AND x>?3 > > Consider using > > ... WHERE x BETWEEN max(?1,?3) AND ?2 AND x>?3
I suspect Dr Hipp means > ... WHERE x BETWEEN max(?1,?3) AND ?2 Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users