On Wed, 25 Aug 2004, Daniel Franke wrote: >Nevertheless, it'd vote for an addition to the manual, e.g. >"When a UNIQUE constraint violation occurs, the pre-existing rows that are >causing the constraint violation are removed prior to inserting or updating >the current row [, i.e. any data the pre-existing row holds, which is not >inserted again, is lost]."
That would be implied by the "OR REPLACE" part of the command, no? > >Regards > Daniel > Christian -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \