On Tue, Oct 28, 2014 at 4:11 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 28 Oct 2014, at 8:06pm, pablo Van <pdvm2...@gmail.com> wrote: > > > WHEN new.DiaHs_Inicio not between (old.DiaHs_Inicio and old.DiaHs_Fin) > > I do not think SQLite supports NOT BETWEEN. > It does. See https://www.sqlite.org/lang_expr.html However Pablo got the syntax wrong. It should be a NOT BETWEEN b AND c But the statement giving problems has extra parentheses: a NOT BETWEEN (b and c) -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
