Hi guys,

I have created a table named users:

CREATE TABLE names

(

    name VARCHAR(255) NOT NULL

);

another table named names2 which is same as users. only table names are different.

I have created a after insert trigger like this:

CREATE TRIGGER trg_names_ai AFTER INSERT ON names REFERENCING NEW ROW AS new_row

FOR EACH ROW

WHEN new_row.name = '<some name>' INSERT INTO names2 VALUES(new_row.name);

The problem is it doesn't care about WHEN clause. Any INSERT query will appear in names2.

Can anyone help?