On Monday, April 28, 2025, Tom Lane <
tgl@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.”
David J.
