On Nov 12, 2013, at 9:49 AM, Simon Slavin <slav...@bigfraud.org> wrote:

>> The merge statement is really missing in sqlite…

Yes, very much so.

> SQLite does have this form of the INSERT statement:

http://www.sqlite.org/lang_conflict.html

Sadly, none of these ‘on conflit’ options are of any use for a merge, which, in 
SQLite, simply cannot be achieved in SQL. One has to resort  to custom, 
procedural logic to implement this. Oh, well… sigh...


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to