Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

> 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?



Sure, 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.


Ah 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: