On Wed, 31 Dec 2014 22:18:02 -0500
Igor Tandetnik <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
