On Wed, 31 Dec 2014 22:18:02 -0500 Igor Tandetnik <i...@tandetnik.org> wrote:
> Well, the WHEN condition on the trigger is always false when the table > is empty. What else did you expect? > > Perhaps you meant something like > > WHEN new.last_price NOT IN (SELECT last_price ...) Ops, you're right ;). Sorry about that. Thank you very much! -- Linux 3.18.1: Diseased Newt http://www.youtube.com/DanielFragaBR http://exchangewar.info Bitcoin: 12H6661yoLDUZaYPdah6urZS5WiXwTAUgL _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users