On Tue, Oct 28, 2014 at 4:11 PM, Simon Slavin <[email protected]> wrote:
> > On 28 Oct 2014, at 8:06pm, pablo Van <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
