Hot answers tagged

1

Some of the columns in the WHERE clause may contain NULL, anything compared with NULL (unknown) results in NULL as a result, which is different from TRUE, so the predicate fails. Testing your trigger with rows that match shows that the trigger is working. A Fiddle with your setup If you want to treat null as don't care, you can use COALESCE in the following ...


Only top voted, non community-wiki answers of a minimum length are eligible