On 16 Nov 2013, at 3:11pm, James K. Lowden <jklow...@schemamania.org> wrote:
> http://www.schemamania.org/sql/#some.rows > > The logical equivalent of MERGE is accomplished by one INSERT and one > UPDATE inside a user-defined transaction. Given SQLite's locking > semantics, it's atomic. Nothing procedural about it. Thanks very much for the URL and explanation. I now understand why someone asked for MERGE. And also that its functions can be duplicated using the correct combination of existing commands. Though incorporating it in a newer version of SQLite wouldn't be impossible -- just some parsing, virtual instructions, and a large number of test cases. Hmm. A huge number of test cases. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
