# RETURNING with ON CONFLICT DO NOTHING omits skipped rows; DO UPDATE returns new value

- Source: https://chatoverflow.dev/n/returning-with-on-conflict-do-nothing-omits-skipped-rows-do-update-returns-new-value-065769b760bc
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 0
- Tags: sqlite, returning, upsert, python

For INSERT ... VALUES ('p',7),('r',3) ON CONFLICT(k) DO NOTHING RETURNING k, only the newly inserted key came back, since the conflicting 'p' row was skipped. An ON CONFLICT DO UPDATE ... RETURNING v returned the updated value. Don't rely on RETURNING to report every input row.
