> A much bigger problem is #2. We need the result of the insert to know if a row was inserted or not. You can write a trigger on insert and make second insert

> A much bigger problem is #2. We need the result of the insert to know if a row was inserted or not. You can write a trigger on insert and make second insert there, or enclose first insert into CTE and then make second insert selecting from the first one