>ON UPDATE TO album WHERE new.pls_id != old.pls_id
> It works until new.pls_id or old.pls_id is null. The rule is still called
> (based on my test), but the "DO" query is not executed correctly. The
> values in "album_edit" are not updated.
To compare "NULL" to something is allways a bad ide
Marc Boucher <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE RULE albed_updalb3_rl AS
>ON UPDATE TO album WHERE new.pls_id != old.pls_id
> DO
>UPDATE album_edit SET pls_id=new.pls_id WHERE alb_id=new.id;
> It works until new.pls_id or old.pls_id is null. The rule is still called
> (base
