On 27 Mar 2019, at 2:40pm, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> So what I'm looking for is some kind of "ON CONFLICT (col1, col2) OR CONFLICT > (col1, col3, col4, col5) DO UPDATE". Can't be done in a single instruction. The nearest you can get to this would involve using triggers: <https://www.sqlite.org/lang_createtrigger.html> Unfortunately this just shifts the difficulty to a different kind of statement. Can I ask what it is that you're trying to do ? This smacks of trying to add 1 to an existing value or something like that. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users