On Monday, April 28, 2025, Tom Lane <t...@sss.pgh.pa.us> wrote: > > AFAIK, "ON CONFLICT" is a Postgres-ism. Exactly which constructs > in exactly which other databases are you citing as precedent? >
I confirmed the SQLite reference from the original email. “The upsert above inserts the new vocabulary word "jovial" if that word is not already in the dictionary, or if it is already in the dictionary, it increments the counter. The "count+1" expression could also be written as "vocabulary.count". PostgreSQL requires the second form, but SQLite accepts either.” https://sqlite.org/lang_upsert.html David J.
