SQLite Forum

Error with upsert and trigger WHEN clause?
Login
Note also that this will **explode** if you attempt to operate on the same name with different cases.  You would fix this deficiency by adding a `COLLATE NOCASE` to the table definition for the column `Items.name`.