Hi Leo,
You only want each author to be added once to the the `authors` table, even if they have written multiple books; is that what you're saying?
Assuming this is the case, I imagine that you could start by deleting potentially existing authors, as you do for your bookshelf table:
delete from authors where name = extractValue(new.xml, '/form/details/author');
Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet