On Mon, Mar 18, 2019 at 10:21 AM Keith Medcalf <kmedc...@dessus.com> wrote:
> requires a "gentlemen's agreement" to only put positive values in the > position column (meaning the database cannot enforce this, you need to do > it at the application level) > Can't this be done with a before insert trigger? sqlite> create table f(t); sqlite> create trigger foo before insert on f begin select raise(ABORT, 'be positive') where new.t<=0; end; sqlite> insert into f values(5.5); sqlite> insert into f values(0); Error: be positive Wout. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users