> The result is as follows:
> INSERT INTO test VALUES(1,'2000-10-11 12:00:00',-20.2);
> NOTICE: Fired INSERT
> INSERT 0 0
> UPDATE test SET value = 1000.0 WHERE epoch = '2000-10-11 12:10:00' AND
> sensor_id = 1;
> UPDATE 0
>
> The insert notice can be shown!
> The update notice is not there!
>
> Why?
My guess...
Because there are no rows the update matches? By returning NULL, you
are aborting the insert (see INSERT 0 0) and thus there are no rows for
the update to do so no triggers are run.
