Re: Do we always have to update or insert? Why can't we just relate?
From: BTDT <dcressey_at_detma.org>
Date: 17 Oct 2005 11:42:16 -0700
Message-ID: <1129574536.326201.173990_at_f14g2000cwb.googlegroups.com>
Date: 17 Oct 2005 11:42:16 -0700
Message-ID: <1129574536.326201.173990_at_f14g2000cwb.googlegroups.com>
I don't think you understood Marshall's suggestion.
M isn't saying it should insert a duplicate row. He's just saying that
it's unnecessary to report an error, if the row to be inserted is
already there. No action is necessary. No insertion, because
inserting would be an error. No error flag, because the row you
wanted in the table is (already) in the table.