I want to select a bunch of items and insert them somewhere else. If the insert fails because of a duplicate primary key or unique constraint, I want to abandon that particular item and continue with the rest. This code outlines my logic. Is this correct for what I'm trying to accomplish?
BEGIN
FOR SELECT DO BEGIN
BEGIN
INSERT
END /* INSERT */
WHEN GDSCODE unique_key_violation DO
BEGIN
/* NOP */
END
END /* SELECT */
END /* PROCEDURE */
