2 ms·
> Returning looks nice, though! Particularly that it can return "one result row for each database row that is deleted, inserted, or updated" rather than just on
by masklinn 6y ago
> Returning looks nice, though! Particularly that it can return "one result row for each database row that is deleted, inserted, or updated" rather than just one.
That… seems normal? Returning just one row would make no sense, how would even a trivial `RETURNING id` work otherwise?
- scottlamb 6y agoSure, but I'm comparing to last_insert_rowid(), which can't do that. Also, last_insert_rowid() (by definition) doesn't work with "without rowid" tables, where returning can.
- masklinn 6y agoAh I see, I was a bit confused because I'm used to RETURNING from pg and I've been waiting for sqlite to add it for a very long time. Especially since ON CONFLICT was added as it made the issue even worse.